HELP NEEDED FOR LOGSHIPPING IN MS SQL SERVER 2008

  • Hi all....

    I want to implement log shipping.I have both my server in sql server 2008.On the secondary server the database is restore with norecovery option.I have schedule the logshipping and the backup of transaction log is copied to the secondary server.Now I want to restore backup of transaction log to the database on the secondary server.

    Plz suggest how can I restore the backup of transaction log.Does Ms sql server restore the latest copied transaction log or should I have to prepare a batch file to restore the transaction log backup.

    plz help me to solve the issue....

    thx in advance...

  • Sql server takes care of restoring the log backup files on the secondary server.You need not make a batch file for this.The restore job on the secondary server will do this. If your primary server is failed then only you need to restore the log backup file manually.

Viewing 2 posts - 1 through 1 (of 1 total)

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