SSR and SQL

[alex_rose]

Hi,

Can someone shed some light on how SSR does incremental SQL backups? Before I recommend it to a customer I need to be sure I understand how it works so I don't look like an idiot!

Thanks

[criley]

SSR backs up at the block-level so not sure I understand your question...

[alex_rose]

I thought there was an option for it to use VSS, otherwise how does it create coherent backups of Exchange and SQL?

[criley]

There is an option called 'Perform Full VSS Backup' but that is specific to Exchange - it sends a request to VSS to perform the transaction log truncation.

As far as SQL is concerned, there really is nothing you need to do. A full SSR backup will interact with VSS in order to get a good backup of SQL.

As always, I would recommend you test this to confirm it works in the way you need it to.

[alex_rose]

Thanks Chris,

1 final question, you mention that a full backup will make a good SQL backup, what about incremental images - will that just record changes to the backup in the same way an incremental of the filesystem does?

[criley]

That's right. Same principal as a standard file system backup.

FYI: please refer to the SCL for supported versions of SQL:

http://www.symantec.com/docs/TECH157280

[alex_rose]

Thanks Chris.

[criley · Accepted solution]

No problem - please mark thread as solved :)