Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between restoration and recovery in
SQLServer?
- 3 Answers
- 11837 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Explain what is cte (common table expression)?
Explain features and concepts of analysis services?
What is spatial and temporal data?
How to send email from database?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are diverse clauses that form a part of sql?
Is sql different from sql server?
What is 1nf 2nf and 3nf?
What do you mean by recursive stored procedure?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Do you know what is user defined datatypes and when you should go for them?
What is the difference between a clustered index and a non-clustered index?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is change tracking in sql server?
What is the significance of master, tempdb and model databases?
