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
Can I delete event logs?
What is a mixed extent?
What is 2nf normalization?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can an entity have two primary keys?
explain databases and sql server databases architecture? : Sql server database administration
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is the osql utility?
Explain about Joins?
What are the properties of sub-query?
what is hash nonclustered index
What is difference between equi join and inner join?
What is difference between view and materialized view?
Can primary key be a foreign key?
How to insert multiple rows with a subquery?