SQL Server Indonesia User Groups Community April 2009 - Posts - Baby SQL ... (^.^)
Welcome to SQL Server User Group Indonesia
Sign in JoinHelp | Sign In Live ID

April 2009 - Posts

Error: Cannot perform a differential backup after applying SQL Server 2005 SP2

Full error message yg gw terima, walaupun seminggu sebelumnya sudah pernah melakukan full backup:

Cannot perform a differential backup for database "xxx", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option

 

Di readme SQL Server 2005 SP2, tertulis:

3.2.6 SQL Server 2005 SP2 Changes the SQL Writer Service Default Startup Type and Default State

Note the following changes to the SQL Writer service default startup type and default state:

    * The SQL Writer service startup type is changed from Manual to Automatic.

    * The SQL Writer service default state is changed from Stopped to Started.

 

Solusi: Kembalikan konfigurasi SQL VSS Writer ini ke manual, dan default state adalah Stopped.

Posted by David | with no comments
More Posts