After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state

When restoring multiple backups, each backup needs to use the NORECOVERY option to keep the database in a loading state so additional backups can be restored. However, because the database is still in LOADING, you may encounter an unusable transaction log backup, leaving you unable to restore the file. To reset the status of the database, open Query Analyzer and use T-SQL to issue a BACKUP command:

RESTORE DATABASE Northwind WITH RECOVERY

This command resets the status of the “Northwind” database and allows users to access it. No additional restores can be issued after this command is executed.

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...

Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy,...

Create a backup file of a SQL Server database?

Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on...

redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...