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 ------------------
