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
    mala, Dec 4, 2009
    #2

  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
    satya, Dec 7, 2009
    #3

Share This Page