SQL Server Performance

Log shipping & Backup - Restore

Discussion in 'SQL Server 2008 General DBA Questions' started by mala, Dec 4, 2009.

  1. mala New Member

    Hi,
    I have a very basic fundamental question...
    Can i use my log shipping logs to restore database to do the point in time recovery.
    If not is it possible to do this in a diffrent way to restore using log shippping logs.
    Thanks
  2. satya Moderator

    Welcome to the forums.
    Yes it is possible to achieve point in time recovery with log shipping, it is the basic functionality of what is offers.
    See http://msdn.microsoft.com/en-us/library/ms187103.aspx which talks thru on how you can achieve this.
    Bear in mind for the recovery the Log shipping is a manual process and to achieve the RECOVERY quickly DATABASE MIRRORING helps a lot, al the information about such high availability best is to update your local copy of books online http://sqlserver-qa.net/blogs/sql2008/archive/2007/08/01/1216.aspx fyi

Share This Page