What are the challenges you face when working across database platforms? Take the survey

differential backup

jonesrob797jonesrob797 Posts: 4
edited July 27, 2015 5:55AM in SQL Backup Previous Versions
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


  • Options
    Hello jonesrob797,

    To resolve this error you will need to take a full backup.

    In order to perform a differential backup, SQL Server requires that a valid, full backup has been completed on the database being backed up.

    If a full backup has been performed, the following conditions will require that another full backup be taken:

    * The recovery model had been changed without taking a full backup
    * A SQL maintenance plan task had changed the recovery model (reindexing can cause this)
    * A backup specifying TRUNCATE_ONLY had been run on the database
    * The database was detached from another server and attached to the current server

    Please also see our documentation here:
    http://documentation.red-gate.com/displ ... +not+exist

    I hope this helps.

    Kind Regards,

    Nicholas Kneeshaw
    Redgate Support
Sign In or Register to comment.