I have a 200GB database running on SQL Server 2008 R2 Enterprise Edition. I just recently partitioned it in order to archive 11 months of history, so it was pushing 400GB prior to archiving.
Our company has 2 data centers in order to implment DR solutions. Most of the databases are at DC1 where there is tape backup infrastructure, where DC2 doesn't have tape backup capability.
This VLDB of 200GB resides at the DC2 location with no tape backup infrastructure. Our server team stopped doing tape backups about a year ago when the database .bak file exceeded 90GB and became too large to snap back to DC1 to backup to tape. I keep 2 disk copies of the .bak file, but still am concerned if a recovery is needed that requires going back more than 2 days.
I am looking for solutions. I thought I could setup a log shipping solution from DC2 to DC1, then each night stop the log shipping and run a backup of the secondary standby, but am concerned it could through the ability to start log shipping into a tiz. I have been doing a lot of research and see that it could cause a problem, but if a standby can be connected to and read from, you'd think a backup could be done.
The database grows by 30GB a month with a daily average of 1-2GB a day, so the traffic to log ship from DC2 to DC1 should be manageable. It is a vendor supplied database, so we try very hard not to modify it to support our environment, although, I did just partition it with the vendor's approval.
Anyone have any ideas of how best to save .bak files to tape from a location without tape infrastructure?