|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
VSS and SQL serversIf 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 Infomax (Info***@discussions.microsoft.com) writes:
> If SQL 2000/2005 is running on a Windows 2003 Server (SP1) and I run a Whether it does or not is irrelevant, but best would be if it didn't, > full backup using NTBackup weekly, does VSS backup the SQL databases > through this full backup? 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 |
|||||||||||||||||||||||