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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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.