Log Shipping "out of sync" but none of the jobs are failing
All we need is an easy explanation of the problem, so here it is. I've configured a log shipping from a server, to the same server, only with a different…
Log shipping large DBs – what about the log?
All we need is an easy explanation of the problem, so here it is. I'm currently setting up log shipping of a large DB (Approx 1.5TB) and am wondering what…
After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow
All we need is an easy explanation of the problem, so here it is. We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all…
SQL Server Log Shipping: File copy options?
All we need is an easy explanation of the problem, so here it is. I usually use redgate sql backup which has a transaction log copy mechanism built in. If…
Creating Users on secondary server in log shipping
All we need is an easy explanation of the problem, so here it is. I have a production Server say ServerA I have setup log shipping to ServerB which is…
How does Log shipping know to keep track
All we need is an easy explanation of the problem, so here it is. I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server…
Remove the log shipping configuration on the secondary server, when the primary is no longer available
All we need is an easy explanation of the problem, so here it is. My primary server with SQL Server 2005 broke down, so I've started up the log-shipped database…
Best way to migrate a huge SQL Server database with low downtime over network
All we need is an easy explanation of the problem, so here it is. Problem definition Our database server needs to be transferred to an other datacenter. It runs on…
SQL Server logshipping: Extend the LS_Alert window
All we need is an easy explanation of the problem, so here it is. We have a logshipping setup, where the LS_Restore job on the secondary database is switched off…
SQL Log Shipping – What is the date time format used by transaction log file name?
All we need is an easy explanation of the problem, so here it is. Looking at my SQL log shipping file names (following is an example) Q:\Backups\LogShipping\MyAudit\MyAudit_20201027165400.trn What date time…