Home Forums SQL Server 2012 SQL 2012 - General Can we backup our cluster databases directly to tape using native backups (without using any third party tool) ? RE: Can we backup our cluster databases directly to tape using native backups (without using any third party tool) ?

  • Joy Smith San (5/5/2015)


    Snapshot of the disks is being done by respective team I believe.

    So are you saying, we don't need database backups from sql server instance if the snapshots of the disks is done ?

    If you're in the extremely large database sphere, you may find that backups running for 26 hours just doesn't work. Especially when restores can take 30 hours or more. Few businesses find this acceptable. So yeah, for very large databases, SAN snapshot & recovery is frequently the answer. BUT, this does mean point in time restores go away and this has lots of implications. This must be discussed with the business and planned for in regards to your recovery point objectives and recovery time objectives. Further, you have to make sure that your SAN snapshot capabilities are compatible with SQL Server. Some of them take this into account. Some don't. You need to test a restore from the snapshot to ensure you're not just corrupting your databases.

    This is absolutely not a minor task.

    And also in case of tapes in two node cluster, do we need to attach the tape device to both the nodes ?

    Thanks alot.

    San.

    If you're in a cluster, you can't attach the tape directly to one of the machines and expect it to work in a failover situation. If the system is failed over because the server went down, nothing will be accessible. It would have to be attached to a different machine in this situation and accessed remotely (making it even slower).

    "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