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.