Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: Differential Backup Failing

    Hi, I shifted a database from one machine(by detaching the db) and then attached it to a new machine.
    Then i took a full backup of this db on the new machine, however, the subsequent Differential backup fails with following error:
    "Cannot perform a differential backup for database "YourDB", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. "
    By checking the msdb.backupset table; the entry of full backup taken earlier has NAME field NULL.
    Any idea????
    Cheers!





    !Direction is More Important than Speed!

    http://talatnauman.blogspot.com/

  2. #2
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Angry

    Folks, any suggestions??
    Cheers!





    !Direction is More Important than Speed!

    http://talatnauman.blogspot.com/

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Rather than detach - reattach, try backing up the database on the old server and then restoring to the new server and then retry the whole process above.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I think you're missing something. The error you posted clearly indicates that the database has never been backed up on the instance with full backup. Try to retrace your steps and see if the situation changes.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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