what is difference between restore and recovery?

  • can any one reply me please

  • Restore is what you do with backups. Take the backup file and turn it back into a database.

    Recovery is something that SQL does every time it brings a database online. It goes through the transaction log and ensures that the database is transactionally consistent (all transactions that had committed when the DB shut dows are reflected in the data file, all transactions that had not are rolled back). That process of analysis, roll forward, roll back is called recovery.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank u

  • Restore ---> For replacing any particular file in the database, we go for the backup data(which is a stored file). Replacing a file from the stored backup represents as "restore"

    Recovery---> If any database corruption made, then the Database need to be rolled back before the time of corruption.

    Nandhini

  • ksnandhinee (12/15/2008)


    Restore ---> For replacing any particular file in the database, we go for the backup data(which is a stored file). Replacing a file from the stored backup represents as "restore"

    Recovery---> If any database corruption made, then the Database need to be rolled back before the time of corruption.

    Nandhini

    This post addresses only special cases therefore it might confuse people out there.

    I suggest to go with Gail's post.

    Restore is the phisical act of restoring files from tape or any other backup device.

    Recover may involve rollback or rollforward.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Also, recovery allow you go place the database to a point in time. For example, someone drops a table by mistake at 8:30 AM. You can restore your database using the backup prior to the 8:30 AM drop. This backup may be from midnight. All the transactions since midnight would be lost with only the restore procedure. After the restore to midnight, recover the database to a time before the table drop. For example, you can recover the database until 8:29 AM. This allows you to retain as much data as possible prior to the table drop.

  • redwinec (12/16/2008)


    Also, recovery allow you go place the database to a point in time.

    That's restore, not recovery. You can, using tran lock backups, restore a database to a point in time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • The two words do get used for either purpose.

    It is correct to say that recover is the process of getting your database working again, and restore is a technique you can use to achieve this.

    It is also correct to say that cleaning the floor is a process, and a Hoover is a technique that can be used to do this. This does not stop most people saying they hoover their floor (even when they use a Dyson).

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • thank u mam

  • Restore is process ro any database backup to existing database or create a new database.

    and

    Recovery is the process to take database online and suppose u restore first full backup with norecovery then apply all transactional log backups with norecovery, and last u have to alter database with recovery to bring online.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • This was removed by the editor as SPAM

  • Please note: 10 year old post, and your definition of recovery is incorrect. What you describe is a restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 12 posts - 1 through 11 (of 11 total)

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