September 28, 2007 at 8:07 am
What is difference between Restore & Recovery
can u any body explaine those things
at least Three points
September 30, 2007 at 3:51 am
A restore, simply, is replacing the existing database with a combination of full, differential and log backups (varying combinations).
A recovery occurs when SQL Server fails and is restarted. Transactions are rolled back or forward to ensure database consistency. This is done by default.
And for a third difference (as you requested). Restores are manual, recovery is automatic!
September 30, 2007 at 10:59 am
Depends on the context.
If you are talking about backups:
restoring is creating the dtaabase from the backup file - by default this will also recover but you can prevent this step. You can also create a standby file to undo the recover step later which will leave the database as recovered but read only.
Recovering is rolling forward and backward the transactions in the database to bring it to a consistent and readable state - sometimes called online. Note you can set the database to be readable without recovering it.
This recovery is similar to the process that the server will go through at startup for each database so that any transactions that were in process at shutdown can be dealt with.
If you are talking about DR
Restoring usually means creating (and "recovering") all the servers, clients, infratructure, ... Recovering means bringing them into a consistent state - reconciling databases and dealing with the times of backaups, same for external files and clients so the the system can be brought online.
Cursors never.
DTS - only when needed and never to control.
September 30, 2007 at 9:00 pm
I think Nigel has a great explanation. It definitely depends on the context in which you are discussing things.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply