Database status shows as "restoring" after restoring a database, and differentials/tlogs backups.
How to get database online?
Last RESTORE command did not include the WITH RECOVERY command
NOTE: This is a function of native SQL Server, not LiteSpeed.
WORKAROUND:
You need to use the native SQL Server command WITH RECOVERY option, with your database RESTORE command, to bring your database online as part of the restore process.
This is of course only if you do not intend to restore any transaction log backups, i.e. you only wish to restore a database backup and then be able to access the database.
Example:
RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE,RECOVERY
Use the restore database wizard in SQL Server Management Studio. You can select the specific file locations, the overwrite option, and the WITH Recovery option.
