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 is the rdl file?
What are the new features of sql server 2012 reporting service?
What command is used to delete a table from the database in the sql server and how?
What do you understand by a stored procedure?
Explain what is public role in sql server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is intellisense?
Mention the differences between substr and charindex in sql server.
write an SQL query to list the employees who joined in the month of January?
Is foreign key a primary key?
Explain can you implement data mining in ssrs?
What is a covering index?
Do you know what is similarity and difference between truncate and delete in sql?
What is the difference between for trigger and after trigger?
Define left outer join in sql server joins?