Martin Stephenson (12/6/2012)
Log shipping seems to be ok but I dont like being left with huge numbers of TRN files and no regular BAK files.
Log shipping does not remove the need for full backups.
You need regular full backups, not for the log shipping, but for normal recovery strategies. In the case of a disaster or accidental delete, you absolutely do not want to be restoring a full backup then months of log backups.
I have scripted a set of daily bak and trn routines that i can schedule to build fresh copy every day but this leaves me humping 90Gb across a WAN link everyday, which makes the Infrastructure team a little cross.
Why do you need to copy all 90 GB every day? Are you doing something odd like switching to simple recovery model before taking backups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability