What is difference between restoration and recovery in
SQLServer?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between SQL notification and SQL invalidation?
How can you fetch alternate records from a table?
How to insert multiple rows with one insert statement in ms sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Can we use where clause in union?
What is left outer join in sql server joins?
What is collation sensitivity? Explain different types.
What extended events?
What is the contrast between sql and mysql?
Do you know what is rank function?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are the different types of upgrades that can be performed in sql server?
How to create a local temporary stored procedure?
Explain system rowset functions?
What different steps will a sql server developer take to secure sql server?