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

What do you mean by an execution plan?

572


What is database dimension? : sql server analysis services, ssas

628


What is used to replicate sessions between instances in coldfusion clusters?

588


Explain what is “asynchronous” communication in sql server service broker?

499


How do you delete duplicate records in sql server?

515






What are data driven subscriptions?

79


Which sql server is best?

522


What do you mean by subquery?

589


What is proper subset of candidate key?

562


on line cluster can we make if yes tell me the procedure

1517


Which is the main third-party tool used in sql server?

480


What is dml command?

555


What is catalog views?

614


what's the difference between a primary key and a unique key? : Sql server database administration

509


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1436