The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database

Support for Windows Server 2003 ended on July 14, 2015

Microsoft ended support for Windows Server 2003 on July 14, 2015. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

INTRODUCTION
Note 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



More information
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:
2005-03-07 12:53:14.17 spid54 Database msdb: IO is frozen for snapshot
Date Time spid52 Database Northwind: IO is frozen for snapshot
Date Time spid53 Database pubs: IO is frozen for snapshot
Date Time spid55 Database model: IO is frozen for snapshot
Date Time spid51 Database master: IO is frozen for snapshot
Date Time spid51 Database master: IO is thawed
Date Time spid52 Database Northwind: IO is thawed
Date Time spid53 Database pubs: IO is thawed
Date Time spid54 Database msdb: IO is thawed
Date Time spid55 Database model: IO is thawed
Date Time backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52), pages dumped: 1, first LSN: 5:268:1, last LSN: 5:272:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239}2'}).
2005-03-07 12:53:16.72 backup Database backed up: Database: Northwind, creation date(time): 2000/08/06(01:41:00), pages dumped: 1, first LSN: 25:156:1, last LSN: 25:160:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239}5'}).
2005-03-07 12:53:16.72 backup Database backed up: Database: pubs, creation date(time): 2000/08/06(01:40:58), pages dumped: 1, first LSN: 5:192:1, last LSN: 5:196:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239}4'}).
2005-03-07 12:53:16.89 backup Database backed up: Database: master, creation date(time): 2005/03/07(12:47:00), pages dumped: 1, first LSN: 180:42:1, last LSN: 180:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239}1'}).
2005-03-07 12:53:16.89 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1, first LSN: 92:370:1, last LSN: 92:374:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239}3'}).
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.


References
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
828481 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
गुण

आलेख ID: 903643 - पिछली समीक्षा: 02/26/2013 19:54:00 - संशोधन: 3.0

Microsoft SQL Server 2000 Enterprise Edition, Microsoft SQL Server 2000 Personal Edition, Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2000 Workgroup Edition, Microsoft SQL Server 2000 Developer Edition, Microsoft Windows Server 2003, Datacenter Edition (32-bit x86), Microsoft Windows Server 2003, Enterprise Edition (32-bit x86), Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems, Microsoft Windows Server 2003, Standard Edition (32-bit x86), Microsoft Windows Server 2003, Web Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Enterprise Evaluation, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Standard

  • kbtshoot kbinfo KB903643
प्रतिक्रिया