Telenet Cloud Online Help

Precautions when making backups of SQL databases

Precaution: In some cases VSS can trigger SQL Server 2005 to perform full backups automatically. This can lead to useless differential backups of databases.

Symptoms:

Upon restoring your database, this can result in an unexpected failure.

Causes:

The SQL Server 2005 Sp2 installation will activate SQL Writer Service. This service will automatically write a full backup to the Shadow Volume if VSS is activated and open files are written to the Shadow Volume. This can happen upon any event in which OnlineBackupClient encounters a locked file and addresses the VSS interface to get a shadow copy of this file.

Resolution:

Configure OnlineBackupClient correctly by either switching off the SQL Writer Service in case you wish to make a backup of SQL databases using OnlineBackupClient or switch off VSS in OnlineBackupClient options.

2 (1)
Article Rating (1 Votes)
Rate this article
Attachments
There are no attachments for this article.
Related Articles
Error during backup of an SQL database: Could not locate entry in sysdatabases for database [name]. No entry found with that name.
Viewed 12412 times since Thu, Dec 10, 2009
How to execute differential System State backups on Windows 2008 using the Online Backup Software
Viewed 8429 times since Thu, Dec 3, 2009
Can I back up my server with Online Backup?
Viewed 1746 times since Tue, Nov 18, 2008
Error message during backup ’Reparse point not supported’
Viewed 40656 times since Tue, Aug 11, 2009
Which files can be backed up?
Viewed 1638 times since Tue, Nov 18, 2008
How can I verify whether a backup was successful?
Viewed 1678 times since Tue, Nov 18, 2008
How do I make a backup?
Viewed 2331 times since Fri, Dec 5, 2008
How can I add additional files to my backup task?
Viewed 7311 times since Tue, Nov 18, 2008
How to backup/restore an Exchange database?
Viewed 1528 times since Tue, Nov 30, 2010
Error message during backup: Could not find file "C:WINDOWSTEMPxxxxxx.dll'
Viewed 2590 times since Fri, Aug 7, 2009