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 does <> symbol mean?

0 Answers  

What does normalization do to data?

0 Answers  

what is the disadvantage of SQL Loder?

1 Answers   TCS,

How many joins in sql server?

0 Answers  

Diffrent types of function

1 Answers   Wipro,

What are the character string functions supported by sql server 2005?

0 Answers  

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

Explain about temporary stored procedure?

0 Answers  

What is merge replication?

0 Answers  

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

How many types of triggers are there?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories