Sunday, October 16, 2011

What Is Difference Between Restoration and Recovery In SQLServer

These two words Restore and Recovery are very interesting in the field of database.  

Restoring means restore the data , which data we have as Backups. Suppose we have backup of database and we want to restore the data into database this process is known as Restoring or Restoring of data.

1. Recovery Is nothing the process after the fail over the database. After fail over the database we are going to take the data backup through Backup Strategy, then the process is known as Recovery or Recovery of data.
2. Applying redologs to the database to roll it forward till the point of failure, typically using current redo log files and online redolog file.
3. Recovery is process when Archive log files are recovered or brought back from Archive log destination to Database.
Restoration and Recovery. Recovering Deleted Files. Restore Sequence and Understanding NORECOVERY and RECOVERY. Understanding How Restore and Recovery of Backups Work. Restore and Recovery Overview. BACKUP and RESTORE in SQL Server. What is difference between restoration and recovery in SQL server 2012. in sql server 2008. in sql server 2005. Disaster Recovery for SQL Server Databases. Backup & Restore. what is difference between restore and recovery.


Post a Comment