load status

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Do you why I am getting a 'loading' status on my database after I finished restoring my database from a backup file ? Is it actually loading the data into the database ? Any Idea ?

Thanks for your help

-- Anonymous, November 22, 2000

Answers

Ogechi,

Somehow an option has been set that essentially tells SQL Server that you do not want to go directly back in to operation with your database.

For instance, in SQL Server 2000, using Enterprise Manager, I can select the 'Leave database nonoperational but able to restore more transaction logs' option when restoring. If I do, Enterprise Manager will indicate that the database is loading.

One way to deal with this is to simply restore again and be sure to avoid the nonoperational or read only option.

Hope this helps,

Eric

-- Anonymous, December 01, 2000


Moderation questions? read the FAQ