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
State the difference between local and global temporary tables?
Explain atomicity?
Can we use where clause with group by?
What are alternate keys?
How to modify an existing user defined function?
What is open database communication (odbc)?
What is tempdb database? : SQL Server Architecture
What is the main difference between ‘between’ and ‘in’ condition operators?
What is Federation Root Database?
What is Cross Join and in which scenario do we use Cross Join?
Mention what are the core components of ssrs?
Explain what is use of dbcc commands?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How connect excel to sql server?
What are trace files?