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 is meant by referential integrity?

959


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2043


What is dirty read?

1041


What are the pre-defined functions in the sql server?

1030


What are relationships and mention different types of relationships in the dbms

913


What are scalar functions?

949


Can another user execute your local temporary stored procedures?

942


How you can add messages to the nt event log from within a stored procedure?

998


What is a data collection table?

948


What is open database communication (odbc)?

1005


How to use order by with union operators in ms sql server?

969


Explain the steps to create and execute a user-defined function in the sql server?

921


How you can change the database name in SQL SERVER?

1136


Explain DBCC?

911


What is temporal table?

827