Post reply

Restore database

  • June 28, 2013 at 11:00 am

    #276784

    We do weekend full backup, daily differential, and hourly transcation log backup.

    Do I need to do a full backup right after I restore a database (for example , from production to a test server?) so that the backup chain can be consistent,

    Or I don't really, in case we want to restore database later, I just need use the full backup of the database that I used to restore and then use differential and transaction log backup?

    But I found at least from SSMS UI, if you want to restore to point of time, in the listed backup there is no one that I copied from prodution.

    Thanks

  • June 28, 2013 at 11:13 am

    #1628366

    I believe that yes, you would need to run a full backup of the recently restored DB in order to "re-start" the log chain for it.

    If you're going to restore to a point-in-time, then yes, restore the full backup (with norecovery,) then differential backup closest to the time you're aiming for (with norecovery,) then the TLogs up to the point you want (with norecovery except for the last)

  • June 28, 2013 at 11:18 am

    #1628370

    jasona.work (6/28/2013)

    I believe that yes, you would need to run a full backup of the recently restored DB in order to "re-start" the log chain for it.

    Thanks, that is part I want to clarify, for sometims if I don't do a full backup, even I have the full backup copied over from production, the SSMS cannot recognize the backup chain.

  • July 1, 2013 at 1:32 pm

    #1628829

    You can use COPY ONLY option if you need a backup for a test system.

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

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