September 28, 2011 at 2:06 pm
Hi,
server hosting company is maintaining our SQL Server 2008 production cluster server.
As part of database backups, they configured evault backup- directly stores in tapes onlile, not like copying from disk to tape.
We asked them to configure backups locally, but they are it is not a good practice to take backups locally also.
Please guide me on this.
What is if they lose tape in case of any nature disaster?
Thanks.
September 28, 2011 at 2:40 pm
Does that software run a SQL Backup or is it some custom binary? If it's custom, I'd ask for an immediate test of the restore to see that your databases come back correctly.
Other than that, natural disasters can hit disk drives too. You just need them to somehow supply multiple copies of the tape. The reason you'll see people backup to a drive somewhere AND make a tape is because then you get a copy of the backup. It's not that either the tape or the drive avoid disaster, it's that having two sources helps avoid disaster.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply