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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are cursors stored procedures and triggers?

1021


What is history table in sql server?

972


Why we use functions in sql server?

1080


What is the difference between value type and reference type?

922


What are different types of roles provided by ssrs?

150


what are user defined datatypes and when you should go for them? : Sql server database administration

1020


What is a constant or literal in ms sql server?

1048


What is the server name in sql server?

1011


What is an example of a primary key?

993


define and explain the differences between clustered and non-clustered indexes.

1196


What is the exact numeric data type in sql?

1003


How do I install sql server?

893


What is the full form of dql?

985


How will you know when statistics on a table are obsolete?

1082


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1039