CODEWITHSUNDEEP
sql-servert-sqlsql-server-2008-r2database-backups
Nani
Nani

Reputation: 103

Differential Backup problems on SQL Server 2008 R2

I have a maintenance plan that takes full backups on wed and sunday at 12am and a differential backups on Mon. Tues, Thur , Fri and Sat'day. The Problem i came across was when ever a full backup happens on wed and sun the differential backup plan fails specifically for 2 databases 'abc1' and 'abc2' with an error

Executing the query "BACKUP DATABASE XXX TO DISK = failed with the following error:
Cannot perform a differential backup for database "abc1", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.

Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established... The package execution fa... The step failed."

I had to perform a manual full backup for these two databases and had to run the differential backup job manually.

Example : When a full backup job runs on sunday at 12am, the differential fails for the two databases with the above error on monday 12am and i had to manually take full backup on monday for the 2 databases and run the differential job and it run fine on tuesday at 12am and on wed'day when the full backup job runs again, the differential fails again for 2 databases on thur 12am with the same error and i had to do the manual process again.

Upvotes: 1

Views: 296

Answers (1)

Cujoey
Cujoey

Reputation: 147

Try stopping the "SQL Server VSS Writer" service and change the start up mode to manual. You might want to restart your computer.

Upvotes: 1

Related Questions