This article discusses Ntbackup.exe. However, this article applies to all products that use the Virtual Device Interface (VDI), including SQL Server.
The Ntbackup.exe utility uses the VDI to perform a snapshot backup of a Microsoft SQL Server database. When you use this utility, the operation may break the differential backup chain of the SQL Server database and invalidate the differential backups. You may see the following error message when you try to create a differential backup:
Msg 3035, Level 16, State 1, Line 1
Cannot perform a differential backup for database "NTBackupTest", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally
System administrators can use the Ntbackup.exe utility in Windows Server 2003 to back up SQL Server databases when SQL Server is running. When the Ntbackup.exe utility starts the backup process, the following behavior occurs:
- SQL Server opens database files in exclusive mode.
- SQL Server prevents other processes from reading the database files even if the files are being used.
In Windows Server 2003, changes were made to the Ntbackup.exe utility. These changes let you perform a VDI snapshot backup of SQL Server databases. After you successfully run the Ntbackup.exe utility, the following message is written to the SQL Server error log: Before hotfix 828481, the Ntbackup.exe utility did not back up SQL Server databases if any user database used the FULL recovery database model. The Ntbackup.exe utility only worked when all user databases used the SIMPLE recovery database model.
Hotfix 828481 modified the Ntbackup.exe utility to allow for the SQL Server database backup process to also use other recovery models.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Error 800423f4 appears in the backup log file when you back up a volume by using the Volume Shadow Copy service in Windows Server 2003