Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have an SQL server 2005 with SP4, x86. When we attempt to take the differential backup, we are getting the following error message.

Cannot perform a differential backup for database "ABCD", 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.

Any help in resolving this issue is appreciated

share|improve this question

migrated from stackoverflow.com Aug 15 '11 at 21:14

This question came from our site for professional and enthusiast programmers.

2 Answers 2

A differential backup is a "changes only" backup, and therefore can only be done when there is a previous full backup to work from. If you create a new database (or attach one from another server), and don't take a full backup, there no "original backup" to get changes since.

share|improve this answer

You cannot create a differential backup until a full backup of the database has been taken. The backup/restore order is full/differential[/differential].

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.