What is difference between restoration and recovery in
SQLServer?
- 3 Answers
- 10519 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
What is the federation in sql azure?
What are the types of containers in ssis?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Can you tell me about the concept of ER diagrams?
What are advantages of ssrs or why we should use ssrs?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How to add code to the existing article (using improve article)?
How to provide column names in insert statements in ms sql server?
How to delete duplicate rows in sql server?
What is a subquery in a select query statement in ms sql server?
Describe in brief authentication modes in sql server.
Can you name some of the dml commands in sql?
How to make conditional sum in ssrs?
Can we insert data into view sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
