Category: logshipping

Trouble shooting log shipping best links

Below is the collection of excellent problems faced by DBAs and solutions to them .

From Paul Randal:

http://www.sqlskills.com/blogs/paul/category/log-shipping/

http://www.sqlskills.com/blogs/paul/why-could-restoring-a-log-shipping-log-backup-be-slow/

From Bretozar:

Log Shipping FAQ

Log shipping automation:

Suppose you want to set up logshipping for many databases,we can use SQLCMD connect mode to run scripts generated through log shipping.please see below link for more details

http://stackoverflow.com/questions/4127668/scripting-log-shipping-automation/4129566#4129566

how to add users to secondary database:

We can create user on primary and give user appropriate permissions,when backup jobs runs user will be created on secondary too.One thing we have to ensure is we have to create a login with same sid Ā on secondaru too.

http://stackoverflow.com/questions/22545133/creating-users-on-secondary-server-in-log-shipping

This is more of question which i now,I want to link it here since it is from my favourite blogger Remus Rusanu

http://stackoverflow.com/questions/6912675/transaction-log-shipping-together-with-backup-job-conflict/6916158#6916158

Log shipping fails when snapshot is created on secondary server in read only mode or which has active replicas

Why did the restore fail on the log shipped secondary database

http://blogs.msdn.com/b/sqlserverfaq/archive/2011/01/07/case-study-troubleshooting-a-slow-log-shipping-restore-job.aspx