The scenario is basically an SQL Server Database stored on a SAN. I'm trying to implement a backup strategy for this SAN, as on this SAN will be stored the databases for the project.
The suggestion is to use Tape Backups, but I don't know how feasible it is or if this practice is obsolete. I would like to use a secondary SAN as a backup system, but I keep seeing the LTO tapes as the main suggestion for the emergency backup system. The goal is to make it as simple and quick to recovery as possible, having also maximum reliability for the storage solution used as backup.
Is this a correct approach? What is the most implemented backup system, taking in consideration that this will be a data warehousing project that will use SSIS to design the packages and these backups only will save the data.
Thanks in advance for any suggestions
Yes, this is an absolutely right approach. Enterprise SAN storage arrays have remote replication solutions (both synchronous and asynchronous) so you can roll your backup system and backup data from the remote array to LTO tapes on the secondary site with RPO/RTO you can tolerate. It's even possible to do backups in "LAN-less" and "Server-less" modes (see what technology is implemented in your storage systems and check if they applicable to you, because they can provide so called "image" backups, not individual file backups). The most of enterprise class backup solutions are aware of DB features like "begin/end backup state" requirements and etc. The one common issue with all these SAN/storage and backup solutions, they are usually not free.