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

State the difference between local and global temporary tables?

1051


Explain atomicity?

974


Can we use where clause with group by?

858


What are alternate keys?

937


How to modify an existing user defined function?

1036


What is open database communication (odbc)?

1005


What is tempdb database? : SQL Server Architecture

1113


What is the main difference between ‘between’ and ‘in’ condition operators?

1105


What is Federation Root Database?

104


What is Cross Join and in which scenario do we use Cross Join?

976


Mention what are the core components of ssrs?

296


Explain what is use of dbcc commands?

993


how many layers of tcp/ip protocol combined of? : Sql server database administration

939


How connect excel to sql server?

931


What are trace files?

896