Post reply

Getting a Secondary LogShipdatabase out of Read Only Mode

  • February 23, 2007 at 1:59 pm

    #119064

    All

    I have a complete failover system with 30 production databases shiped to a secondary site.  The databases are all in read only mode. 

    I would like to detach/reattach or backup/restore the databases to another instance at my failover facility. 

    Is there anyway to get a copy of the database in its present state without having to restore the transactions logs and break the log shipping?

    Thanks in Advance

    Eric 

  • February 23, 2007 at 4:45 pm

    #691587

    If you need to get your secondary databases online, then you will break log shipping. There is no need to run any log restores on your secondary databases.

    You could just run:

    restore database <databasename> with recovery.

    This will bring your database online to the point till your last log backups have been applied by the log shipping monitor.

     

     

  • February 23, 2007 at 11:46 pm

    #691603

    I believe you can stop sql server to on secondary server and copy the .ldf and .mdf files to the other location and restart the sql services...

    I think your dbs should come back as read only mode...

     

    MohammedU
    Microsoft SQL Server MVP

  • February 24, 2007 at 4:25 pm

    #691619

    I have tried stopping the server and taking the database offline so I can copy the database files. 

    The new attach of the database says the database cannot be used because it is in recovery mode.

      

  • February 25, 2007 at 10:59 pm

    #691651

    Why and how do you need to take the db offline when sql server is stopped.

    Is your dbs in standby mode or loading mode?

    MohammedU
    Microsoft SQL Server MVP

  • February 26, 2007 at 7:46 am

    #691726

    I take the database offline when I want to copy the file and have the rest of my SQL Server functional.  I have also detached the database and Shut down the entire SQL Server before the copy of the data/log files.  

    The failover databases are all in Standby/read-only mode.   

  • February 26, 2007 at 8:28 am

    #691781

    If you have a copy of a log-shipped secondary database that you want to make writable, use RESTORE..WITH RECOVERY.

    RESTORE DATABASE database WITH RECOVERY

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply