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:
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
- 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.
Hotfix 828481 modified the Ntbackup.exe utility to allow for the SQL Server database backup process to also use other recovery models.
ID do Artigo: 903643 - Última Revisão: 29/03/2017 - Revisão: 3