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
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How can you check the version of sql server?
What is an active database?
Explain what is log shipping?
Explain view in sql server?
What is clustered primary key?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is difference between rownum and row_number?
What type of Index will get created after executing the above statement?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is ssrs?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How do you implement session management in SQL Server mode?
What does dml stand for?
What are the types of sql server?