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 meant by referential integrity?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is dirty read?
What are the pre-defined functions in the sql server?
What are relationships and mention different types of relationships in the dbms
What are scalar functions?
Can another user execute your local temporary stored procedures?
How you can add messages to the nt event log from within a stored procedure?
What is a data collection table?
What is open database communication (odbc)?
How to use order by with union operators in ms sql server?
Explain the steps to create and execute a user-defined function in the sql server?
How you can change the database name in SQL SERVER?
Explain DBCC?
What is temporal table?