Home All Groups Group Topic Archive Search About

VSS and SQL servers

Author
12 Nov 2006 1:29 AM
Infomax
If SQL 2000/2005 is running on a Windows 2003 Server (SP1) and I run a full
backup using NTBackup weekly, does VSS backup the SQL databases through this
full backup?

Thanks,
Ted

Author
12 Nov 2006 10:02 AM
Erland Sommarskog
Infomax (Info***@discussions.microsoft.com) writes:
> If SQL 2000/2005 is running on a Windows 2003 Server (SP1) and I run a
> full backup using NTBackup weekly, does VSS backup the SQL databases
> through this full backup?

Whether it does or not is irrelevant, but best would be if it didn't,
because they would waste space.

To backup a database, you need to use SQL Server's own BACKUP command,
so that you get a transactionally consistent backup.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button