Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DAtabase stuck loading

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-18 : 08:26:29
Lloyd writes "I have a database I have restored several times and still stuck in the "Loading" stage. I have searched your web site but none of the results that came up even mention this unless I just missed it. Any ideas? I cannot connect at all to the database."

nr
SQLTeam MVY

12543 Posts

Posted - 2005-01-18 : 10:19:37
If it's loadin then you can't connect. You will have to drop the database and restore again - unless you restored with standby inwhich case just restore the database with recovery.
If you have tried the restore a number of times it probably nmeans you don't ahve enough room (unlikely or it would give an error) have a corrupt backup or something wrong with the server.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -