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

Can we call stored procedure in view in sql server?

0 Answers  

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

What is difference statement and preparedstatement?

0 Answers  

Why do we need normalization?

0 Answers  

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

What command would you use to create an index?

0 Answers  

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

What is factless fact table? : sql server analysis services, ssas

0 Answers  

What is triggers and its types?

0 Answers  

Explain go command in sql server?

0 Answers  

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

What is the difference between left and right outer join?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories