Post reply

How to Ensure Restored Data is Perfect

  • August 22, 2012 at 6:39 am

    #260326

    Hi,

    I have a Maintenance backup plan. And there is a 3 scheduled backups daily. If I restored latest back up in worst scenario, How I can ensure that the restored backup data is perfect data. Please anyone suggest me.

    Thanks in Advance...

  • August 22, 2012 at 6:52 am

    #1528590

    well a restore in SQL server is all or nothing. the backup is an exact copy of the commited transaction data.

    if the backup file is corrupted, the backup simply fails, it doesn't do a best guess or anything like that .

    so if you are sure of when the backup was created, you can be sure the data is current up to that point in time.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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