Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server Backup vs VSS snapshot backup

Author  Topic 

AlenaB
Starting Member

1 Post

Posted - 2009-11-09 : 14:03:35

I open this discussion to have different opinions about backups applications using VSS API snapshot + SQL Writer approach to backup SQL databases and SQL Server backups.
Can anyone give me the pros & cons of using VSS snapshot backups for full and differential backups vs SQL Server backup?
When VSS backups is better, why or opposite. If anybody has experience please share it with me.


Thank you,
Alena

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-09 : 14:28:27
The vast majority of us will insist that SQL Server backups are far superior to any 3rd party tape backup software. DBAs should be responsible for backup/recovery of the databases, and the tape admin team should be responsible for the tapes. In this way, you have the people most familiar with the technologies working on their parts.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Catherine Sea
Starting Member

4 Posts

Posted - 2009-11-10 : 00:38:53
I agree with tkizer.


Catherine Sea
http://www.dynamsoft.com/
http://www.scmsoftwareconfigurationmanagement.com/
Go to Top of Page
   

- Advertisement -