Post reply

query of updated data backup

  • June 18, 2008 at 7:27 am

    #187302

    Hi...

    how i can take todays updated columns backup only?

    Thanx & Regards,

    Mohammed Iftequar Ahmed.

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]

  • June 18, 2008 at 7:47 am

    #830429

    I think what you are asking is if you can take a backup of just data that has changed recently?

    The answer is sort-of. You can take a differential backup that will give you all of the pages that have changed since the last full backup. If you need to restore, you would restore the full backup with norecovery and then restore the differential.

  • June 18, 2008 at 10:04 am

    #830600

    You should be doing log backups as well. those will have the updates, independent of diff backups.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply