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...

What is difference between restoration and recovery in
SQLServer?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I delete event logs?

913


What is a mixed extent?

997


What is 2nf normalization?

1002


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2009


Can an entity have two primary keys?

964


explain databases and sql server databases architecture? : Sql server database administration

942


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1001


What is the osql utility?

941


Explain about Joins?

970


What are the properties of sub-query?

1061


what is hash nonclustered index

948


What is difference between equi join and inner join?

919


What is difference between view and materialized view?

926


Can primary key be a foreign key?

1040


How to insert multiple rows with a subquery?

1107