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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-15 : 07:17:34
|
| venugopal writes "respected sir, what do u mean by "LOADING",when i performinga backup & recovery operation accidently the database went toloading mode & i'm not able to do anything with that databaseplease send me a information about "loading mode" & solution forthat means how i can bring the database from that mode to operating mode" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-15 : 07:20:35
|
| It's not accidental. When restoring a backup the database is put into loading status and is unavailable for general use. This is perfectly normal and will last for the duration of the restore operation. If the restore fails, the database will still be in loading status. You can try restoring again, either over the existing database, or dropping it and restoring to a new database.Books Online has all of the details on backup and restore operations. |
 |
|
|
|
|
|
my question about loading