What is difference between restoration and recovery in
SQLServer?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajesh
Restore means we have a backup files(.bak) and that backup
files can provide all the previous information about the
restored data, Like tables, stored procedure.
Recovery means we have lost(Like tables, stored procedure)
the data but we want to recover that data or information, so
at that time we can perform some actions and that actions is
called recovery.
Is This Answer Correct ? | 4 Yes | 3 No |
Restore is a uploading files back into database
Recovery is missing file finding and reloding in database
Is This Answer Correct ? | 1 Yes | 3 No |
What is sql or structured query language?
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?
1 Answers CarrizalSoft Technologies,
What is the syntax for encrypting a column in SQL Server?
How do you send email on SQL Server?
How to Get the last identity value used
Is INSTEAD OF trigger directly applicable to Table ?
What is bulkcopy in sql?
What is change data capture (cdc) in sql server 2008?
What is difference between inner join and join?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
What are types of scd? : sql server analysis services, ssas
what is the difference between procedure and function.