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

Explain the concept of recursive stored procedure.

0 Answers  

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

Do you know what is xpath?

0 Answers  

What is normalization according to you and explain its different levels?

0 Answers  

What is difference between stored procedure and function?

3 Answers   L&T,

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

How sql server enhances scalability of the database system?

0 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

How much memory that we are using in Logshipping Concept?

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What is cursors?

0 Answers   NA,

How to use user defined functions in expressions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories