December 15, 2008 at 4:34 am
can any one reply me please
December 15, 2008 at 4:43 am
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
December 15, 2008 at 5:27 am
Thank u
December 15, 2008 at 5:42 am
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
December 15, 2008 at 6:18 am
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.December 16, 2008 at 6:56 am
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.
December 16, 2008 at 7:35 am
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
December 17, 2008 at 5:05 am
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
December 18, 2008 at 10:26 pm
thank u mam
December 22, 2008 at 10:42 pm
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.
July 2, 2018 at 12:17 am
This was removed by the editor as SPAM
July 2, 2018 at 9:46 am
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
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply