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...