I have a production SQL Server connected to a SAN and would like your opinion on where is the best location to store the backups. I'm fairly new to the environment and initially found the backups were being kept on the same SAN array (1+0) as the database files. I thought this was bad because if the array controller on SAN failed, I would lose access to the backups and database files.
I moved the backups to the O/S drive (mirrored) of the SQL Server but am now thinking that is not good either. If I had access to another device on the SAN, I would move the backups there (or any other location on the network), but that currently is not an option. I'm thinking that since the SAN is more stable (at least in theory), it's better to have the backups there, even though it's the same array as the database files.
What do you all think? Thanks in advance for your input.
P.S. The O/S drive of the SQL Server is backed up to tape once a day.