Quick Question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Quick Question

If you witness shows that your destination server had something wrong, what is the quickest way to recover the synchronization and keep a standby server. ——————
Bug explorer/finder/seeker/locator
——————
Stop the log shipping and restore the latest database backup from live server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Sayta, If the source database does not have a full backup for a long period, then? ——————
Bug explorer/finder/seeker/locator
——————
]]>