-
Database Stuck on Restoring Mode
Hi
The database is stuck on a restoring mode.
How can i get it back online or in a read only mode?
Sql 2005 Server
Stefan
-
Does restore finish? Did you specify recovery in restore? You can take it back with 'restore database db_name with recovery'.
-
We have jobs that applies transaction logs logs to the standby database. everytime the transaction log gets applied, the database go into a restoring mode. some unknown reason, it got stuck on one of the tansactions log and the database still stay on restoring mode. i stopped the job that applies the transaction log but database still in restoring.
-
going to try that and let you know.
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|