quarta-feira, 27 de junho de 2012

"Cannot perform a differential backup for database... ...Perform a full database backup..."


After installing SP2 on MSSQL 2005 you may get the folowing error:

"Cannot perform a differential backup for database "abc",
 because a current database backup does not exist.
 Perform a full database backup by reissuing BACKUP DATABASE,
 omitting the WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035)
 BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)."

More info: http://adf.ly/A76Se

Just set the SQL VSS Writer service to manual and restart SQL agent service:




Sem comentários:

Enviar um comentário