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 Report Server,Report Manager and Report Builder in SSRS 2005?
How do we know if any query is retrieving a large amount of data or very little data?
Explain the dbcc pintable command when would you use it?
Tell me what is a linked server?
Accidentally i deleted my table. How can i get that table?
What are the difference between “where” and “having” clause in sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
how to change column into row in sql
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
Explain syntax for viewing trigger?
What are the different SQL Server Versions you have worked on?
what is unique and xaml nonclustered index