I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them back in case they blow up. Please let me know if something like this is possible at all.

  • What virtal server platform are you using? VMware? Hyper-V? – Molenpad Mar 3 '17 at 19:47
  • They are hosted on Vmware – user2923332 Mar 3 '17 at 19:54
  • 1
    If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances. – Molenpad Mar 3 '17 at 20:03
  • Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ? – user2923332 Mar 3 '17 at 20:08
  • The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption. – Molenpad Mar 3 '17 at 20:35

We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.

SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.

We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.