Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2015
    Posts
    2

    Unanswered: differential backup

    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

  2. #2
    Join Date
    Jul 2015
    Posts
    2
    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. technet.microsoft.com/en-us/library/ms190412%28v=sql.105%29.aspx 2. sqlbak.com/blog/cannot-perform-a-differential-backup/ Hope that will be useful

  3. #3
    Join Date
    Jul 2015
    Posts
    2
    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).

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •