question

yunusemre avatar image
yunusemre asked

Sql Server ordinary backup vs. snapshot technologies

hi, do you suggest SqlServer ordinary backup methods or snapshot backups like veeam technologies?

what is difference?

Thanks

sql-server-2012backupsql-server-2014backup-restore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
borispinsky avatar image
borispinsky answered

It depends on your disaster recovery strategy , Usually I prefer to combine both:Create my bak files with sql server job and let the veeam to save these files.

I don't like snapshots on sql machines because they create io freeze , It could lead to problems especially on 24/7 systems with Availability groups .

Another option is to use veeam sql server backup module . it should be similar to ordinary backup methods but it will be managed by veeam

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yunusemre avatar image
yunusemre answered

Thank you very much for your answer borispinsky

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.