Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between restoration and recovery in
SQLServer?
- 3 Answers
- 11949 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
How to create an index on an existing table in ms sql server?
what is a join? : Sql server database administration
Explain the flow of creating a cube? : sql server analysis services, ssas
What happens if the update subquery returns multiple rows in ms sql server?
How to create a new table in a given schema?
What are the essential components of sql server service broker?
Explain in brief how sql server enhances scalability of the database system?
What is the difference between varchar and nvarchar datatypes?
What is apply operator in sql?
What is difference between Datepart() and Datename() in SqlServer?
Can an entity have two primary keys?
How to use go command in "sqlcmd"?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Tell me what is difference between clustered and non clustered index?
how you can list all the tables in a database?
