dylanwhite
MIS
I have a database stuck in a loading state. Is there any way i can stop it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database Loading
- Thread starter dylanwhite
- Start date
- Status
You probably ran a RESTORE with the NORECOVERY option, which will keep your database in the LOADING state. The reason is that the database is awaiting the next file to be restored.
Depending on what the last command you ran was, you can run one of these two commands.
If you last restored just the database (RESTORE DATABASE), run:
If you last restored a LOG file (RESTORE LOG), run:
Replace dbname with your actual database name.
-SQLBill
Depending on what the last command you ran was, you can run one of these two commands.
If you last restored just the database (RESTORE DATABASE), run:
Code:
RESTORE DATABASE dbname
WITH RECOVERYIf you last restored a LOG file (RESTORE LOG), run:
Code:
RESTORE LOG dbname
WITH RECOVERYReplace dbname with your actual database name.
-SQLBill
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question