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 ...
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 ...
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 ...