dcsimg
Results 1 to 4 of 4

Thread: Database Stuck on Restoring Mode

  1. #1
    Join Date
    Jun 2007
    Posts
    3

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Does restore finish? Did you specify recovery in restore? You can take it back with 'restore database db_name with recovery'.

  3. #3
    Join Date
    Jun 2007
    Posts
    3
    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.

  4. #4
    Join Date
    Jun 2007
    Posts
    3
    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
  •