2
votes
2answers
861 views

SQL Server Log Shipping: Replace Copy Job with Manual Compress & Copy

I have two instances of SQL Server 2005 STANDARD edition, Server A in New York and Server B in California. Server A has a large database; for DR/BCP purposes, I would like to use Log Shipping to keep ...
0
votes
6answers
3k views

Is it possible to configure SQL Server 2005 to auto-compress backups?

I have created scheduled backup and shrink maintenance plans for my SQL 2005 instances using the tools in SQL Server Management Studio. I am wondering, is there an equally easy method for ...
3
votes
3answers
1k views

Automatically Zip/Manage SQL Server 2005 backups

Is there a nice way to have SQL Server 2005 run nightly backups that are automatically zipped with only the last n backups kept? I know the agent can perform nightly backups, but I think the tricky ...