SQL Server Performance

Log Shipping Database in Standby / Read Only Enquiry

Discussion in 'SQL Server 2008 General DBA Questions' started by michellesbs, Dec 22, 2011.

  1. michellesbs New Member

    Dear Sir,

    I have a Log Shipping database in StandBy mode which the database will Copy Trn file from production database and Restore to this Log Shipping Database(in standby mode) every 15 min.

    But sometime I hope I can trace the Bugs with the Log Shipping database intead of Production database, but I can access to these Standby Mode database, even backup the database.

    Is there any way for me to access the Log Shipping database(in Standby mode) ?

    TQ
    michellesbs, Dec 22, 2011
    #1

  2. satya Moderator

    satya, Dec 23, 2011
    #2

Share This Page