What is difference between restoration and recovery in
SQLServer?

Answers were Sorted based on User's Feedback



What is difference between restoration and recovery in SQLServer?..

Answer / sagi.rahul

Restore is what we 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 consistent

Is This Answer Correct ?    7 Yes 1 No

What is difference between restoration and recovery in SQLServer?..

Answer / rajesh

Restore means we have a backup files(.bak) and that backup
files can provide all the previous information about the
restored data, Like tables, stored procedure.


Recovery means we have lost(Like tables, stored procedure)
the data but we want to recover that data or information, so
at that time we can perform some actions and that actions is
called recovery.

Is This Answer Correct ?    4 Yes 3 No

What is difference between restoration and recovery in SQLServer?..

Answer / chandra mouli paidi

Restore is a uploading files back into database

Recovery is missing file finding and reloding in database

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is sql or structured query language?

0 Answers  


SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,


What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,


How do you send email on SQL Server?

0 Answers   MindCracker,


How to Get the last identity value used

4 Answers  






Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  


What is bulkcopy in sql?

0 Answers  


What is change data capture (cdc) in sql server 2008?

0 Answers  


What is difference between inner join and join?

0 Answers  


A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,


What are types of scd? : sql server analysis services, ssas

0 Answers  


what is the difference between procedure and function.

4 Answers   Thomson,


Categories