Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

differential backup

Status
Not open for further replies.

jonesrob797

Programmer
Jul 24, 2015
1
UA
Hello, receive an error: "Cannot perform a differential backup for database ..., because a current database backup does not exist." Can't fully understand what to do with this
 
Differential backups are a type of backup which stores the changes which have occurred in your database since the last FULL database backup. In order to be able to create a differential backup you will need to have a FULL database backup before. Multiple differential backups can be created later, which store the incremental changes in your database since your last FULL or DIFFERENTIAL backup, but having a FULL backup is mandatory as this is the base for your later backups which are of a different type(differential or transaction log). I can propose a few articles to you.
1. [URL unfurl="true"]https://technet.microsoft.com/en-us/library/ms190412%28v=sql.105%29.aspx[/url]
2. [URL unfurl="true"]http://sqlbak.com/blog/cannot-perform-a-differential-backup/[/url]
Hope that will be useful
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top