Post reply

Can we ran DBCC CHECKDB on Secondary databases in Log shipping:

  • July 21, 2009 at 1:24 pm

    #136718

    Hi,

    We have configured Logshipping in SQL Server 2005. In our secondary server, the hard disk has failed and replaced with new one. Now I would like to check the secondary databases are corrupted or not using DBCC CHECKDB commands.

    All the secondary databases are recovery mode. How should I make sure all secondary databases are good?

  • July 21, 2009 at 1:38 pm

    #1027884

    Add another database to log shipping, recover it, and run dbcc checkdb. You can log ship to any number of databases, and having a 2nd standby to run checks is a good idea.

Viewing 2 posts - 1 through 1 (of 1 total)

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