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.
| Author |
Topic |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2004-01-28 : 04:07:16
|
| Hi, In EnterPrise manager I have a message appearing that the database is loading when I try to access the database it wont allow me to access it. The databas is grey out. How Can I stop the Loading ? |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-28 : 05:43:12
|
| u'r database is in the middle of restore, leave it alone it will be accessible once the restore(loading ) is finished.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-28 : 12:26:34
|
| If the database is in loading state due to a restore occuring with the RECOVERY option being specified, then it will never come out of loading mode until the NORECOVERY option is specified. But what occurred on the system to get it to do this? A reboot? If so, just wait as harshal_in mentioned. If you can't wait any longer, delete then restore the database from the last full backup.Tara |
|
|
|
|
|
|
How to stop Database loading in Enterprise Manager