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
What are cursors stored procedures and triggers?
What is history table in sql server?
Why we use functions in sql server?
What is the difference between value type and reference type?
What are different types of roles provided by ssrs?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is a constant or literal in ms sql server?
What is the server name in sql server?
What is an example of a primary key?
define and explain the differences between clustered and non-clustered indexes.
What is the exact numeric data type in sql?
How do I install sql server?
What is the full form of dql?
How will you know when statistics on a table are obsolete?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration