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
How long are files stored?
Viewed 1430 times since Tue, Nov 18, 2008
Where can I see the files that were backed up?
Viewed 1351 times since Tue, Nov 18, 2008
How can I add additional files to my backup task?
Viewed 7198 times since Tue, Nov 18, 2008
Error message during backup: Could not find file "C:WINDOWSTEMPxxxxxx.dll'
Viewed 2465 times since Fri, Aug 7, 2009
How can I verify whether a backup was successful?
Viewed 1572 times since Tue, Nov 18, 2008
How to create a backup of a network location
Viewed 2315 times since Mon, Aug 31, 2009
How do I make a backup?
Viewed 2239 times since Fri, Dec 5, 2008
The backup button in the Online Backup client is greyed out.
Viewed 1393 times since Mon, Aug 24, 2009
Error during backup of an SQL database: Could not locate entry in sysdatabases for database [name]. No entry found with that name.
Viewed 12265 times since Thu, Dec 10, 2009
How do I add a filter to my Online Backup task?
Viewed 2474 times since Wed, Sep 23, 2009