I am after an independent view of the following scenarios. There are a number of database (SQL Server) backups being written to the same drives as their live production database. Some of these servers are virtual (SAN storage) and others are physical (local storage).
Our DBA made the following comments:
This is more of a risk on physical servers (local storage) than virtual servers (SAN storage) – can anyone explain why?
They also claimed – if they are backing up the data to tape each night, what’s the real risk? I.e. if the drive housing both the data and backups did corrupt or did fail, as long as they have a backup on tape to which they can restore the backup of the data after the hardware/corruption fault has been rectified – is there really any risk?
What’s your view?
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008