Post reply

T-SQL Load Log file to Secondary DB

  • March 11, 2015 at 3:45 am

    #398162

    Hi,

    I am after T-SQL code which will simply load the next T-log backup file from a network share folder to a warm standby db on a secondary server.

    What is needed is a Third server (server x), to participate in log shipping (MULTIPLE TARGETS).

    Primary SERVER (SERVER A)

    Secondary SERVER (SERVER B) Log shipped to via GUI.

    THIRD SERVER (SERVER X) which will contain the same log shipped db from server A.

    This will simply restore the logs from a network share to keep the db up to date.

    Unless there is a better way to achieve this.

  • March 11, 2015 at 6:07 am

    #1783232

    Just get out books online and review the RESTORE LOG section.

    Or you can use SSMS GUI to fully script out your options and then click the Script button to get the script you need. Not a bad way to learn TSQL, although the SSMS GUI is FULL of bugs so ALWAYS review the script before you do something with it!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 11, 2015 at 7:38 am

    #1783277

    Thanks

  • March 11, 2015 at 7:47 am

    #1783285

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply