What is difference between restoration and recovery in
SQLServer?
- 3 Answers
- 10490 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Difference between DELETE and TRUNCATE?
How to backup encryption key ?
How to create a local temporary stored procedure?
What are different types of data sources?
What is a bit datatype?
what is a correlated sub-query? : Sql server database administration
What are the encryption mechanisms in sql server?
What is a synonym for manipulation?
Is ssrs support other database except ms sql server?
What are the drawbacks of reporting in ssrs?
How to create a user to access a database in ms sql server using "create user" statements?
What is data set in report?
What are the default system databases in sql server 2000?
What is the purpose of indexing?
can an order by clause be used in a creation of a view?
