Log Shipping as a reporting database.
I had an issue with log shipping with SQL Backup v. 4.0. this turned out to be my maintenance script for nightly backup and shrink of the log files. Duh changes the LSN number sql guy...But this led me to another question in my research of the issue. With RED-GATE sqlbackup does the log shipping restore have an exclusive lock on the restoring db's tables. I assume that it does not. I ask this because all of my restores are being used for reporting and redundancy not just redundancy.
0 · Share on Twitter