SQL Server Performance

Quick Question

Discussion in 'SQL Server 2005 Log Shipping' started by xiebo2010cx, Feb 4, 2007.

  1. xiebo2010cx Member

    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
    ------------------
  2. satya Moderator

    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.
  3. xiebo2010cx Member

    Sayta, If the source database does not have a full backup for a long period, then?

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------

Share This Page