Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is difference between restoration and recovery in
SQLServer?

Question Posted / sam

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 the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

Can we call stored procedure in view in sql server?

0 Answers  

How to find Duplicate Records In table?

0 Answers   HCL,

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

What are the differences between ms sql server & oracle?

0 Answers  

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

What are secondary xml indexes?

0 Answers  

What is the stored procedure?

0 Answers  

What are the difference between primary keys and foreign keys?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories