Post reply

Restore the data on particular date

  • August 9, 2012 at 8:47 am

    #280059

    Hi Guys,

    I am new to DBA work, i am not sure how to restore the backup file on particular date. Here we will back up the data to one Backup_data_Dump.bak file. So all the back up files will be dumped to one file. i would like to get the backup file on particular date.

    Can you please help me ASAP?

    Thanks,

    Karthik

  • August 9, 2012 at 9:01 am

    #1523862

    To start, you will need to run a RESTORE HEADERONLY against the file to determine which file to restore.

    Here is the entry in Books Online that should help you with the syntax of the command:

    http://msdn.microsoft.com/en-us/library/ms178536(v=sql.90)

  • August 9, 2012 at 12:15 pm

    #1524022

    Thanks for the Prompt reply.

    Still i am getting the latest date. unable to see the whole list of dates in the dump.

    Thanks,

    Karthik

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy