Database in LOADING state - SQL Server Forums

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 in LOADING state

Author

Topic

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-04-11 : 17:56:59

Hi Gurus

Please help me out of this restoration issue.I am restoring a database from backupset, normally this restoration takes 15 min to complete but today it already taken 1hr to restore and still the database is in loading state. Please help me to resore this database as this is a very critical database and in next 4 hr or so testing team will going to test database. waiting for responses ....

Thanks
Chander

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-11 : 18:07:11

You must've selected an incorrect option. It'll never finish if you select the option to apply additional tlog backup files (WITH NORECOVERY option if done via RESTORE DATABASE command).

Redo the restore and make sure to select the option to not apply any more files (WITH RECOVERY option).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-04-11 : 18:11:49

Thanks alot tara for prompt reply ..

I have use restore database abc from disk ='d:\abc.bak' with replace

now shall i add with recovery in the end of restore ? please advice

thanks
chander

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-11 : 18:44:14

WITH RECOVERY is the default so you don't have to put it there. Run the command again but add stats so you can watch the progress.

restore database abc from disk ='d:\abc.bak' with replace, stats

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources