Results 1 to 5 of 5

Thread: backups

  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: backups

    database backups and differential backups

    i took database back up on 01-jan-2005 and from 2nd jan onwards im taking differential backups. if i want to restore the database to a new system, is it sufficient that i restore the back up which i took on 1st jan , and the most recent differential backup ? will the entire data till the last back up date be restored?
    Cheers....

    baburajv

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    From BOL:
    The sequence for restoring differential database backups is:

    1.Restore the most recent database backup.


    2.Restore the last differential database backup.


    3.Apply all transaction log backups created after the last differential database backup was created if you use Full or Bulk-Logged Recovery.

    yes if u restore to the last differential database backup the database will be recoverd to that point of time.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm 99% sure that you'll need to restore the last full backup, plus each differential backup in sequence in order to get back to the state of the last differential dump you've got. In other words, if you are missing the backup from day 13 out of 30, you can only get to the point of the backup from day 12.

    You only explicitly restore the last file, but all of the files need to be present in order for the restore to be successful.

    -PatP
    Last edited by Pat Phelan; 02-01-05 at 01:51.

  4. #4
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    that means if i have 10 differential back ups named 1,2,..10

    i'll have to restore the last full back up (on jan 1st) and then restore each of 1,2,3....10 in order. am i correct?

    one more question.

    BOL (under Differential Database Backups ) says that "A differential database backup records only the data that has changed since the last database backup".

    so is it necessary that i restore full backup & differential backups from 1 to 10

    i think restoring full back up + differential backup no 10 will give me all the data .. i donno whether im correct..

    pl discuss
    Cheers....

    baburajv

  5. #5
    Join Date
    Aug 2002
    Location
    Prague
    Posts
    77
    You have to restore only the last diff. backup made, not the whole sequence.
    See 'Tracking Modified Extents' topic in Books Online for details. mojza

Posting Permissions

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