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 purpose does the model database serve? : Sql server database administration

0 Answers  

What is dknf in normalization form?

0 Answers  

How to create a simple user defined function in ms sql server?

0 Answers  

How to execute the cursor queries with "open" statements?

0 Answers  

Explain user defined views?

0 Answers  

What is side by side migration in sql server?

0 Answers  

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

Can you please differentiate between a primary key and a unique key?

0 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

how many type of indexing in database?

0 Answers   IBM,

Repair mdf file

2 Answers  

For more SQL Server Interview Questions Click Here
Categories