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 is difference between order by and group by?

570


How to list all login names on the ms sql server?

533


How do I connect to sql server database?

472


How to download and install sql server 2005 books online?

534


What stored procedure can you use to display the current processes?

490






Explain time data type in sal server 2008?

545


What is implicit mode in sql server?

552


Define indexes?

601


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

114


What is primary key index?

530


Explain the rules for designing files and file groups in sql server?

543


What is difference between group by and having?

553


What are built in functions?

570


What is trigger in salesforce?

489


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1588