Restoration Part-1

Q: What are the different types of Restore options?

·         Restore an entire database.

·         Restore part of a database.

·         Restore specific files or filegroups.

·         Restore specific pages to a database.

·         Restore a specific transaction log.

Q: Why you require to restore a database?

·         Application failure

·         Server failure

·         Disk failure

·         Database failure

·         Database corruption

·         Research data issue

·         Data corruption

 Q: What is your preparation before database restore happen?

·         Get the version of the destination server.

·         Get the version of the source server on which the backup was created.

·         Match the versions of the source and destination servers.

·         Ensure exclusive access to the database.

 Q: Why database restores fail?

·         Unable to gain exclusive use of the database.

·         LSN’s are out of sequence so the backups cannot be restored.

·         Syntax error such as with the WITH MOVE command.

·         Sufficient space not available on drive.

·         User may not have sufficient permissions to perform the restore.

 Q: Which database contains all types of system tables and do we perform backup and restore for that system tables.

The MSDB database is the database with the backup and restore system tables.

Yes, we can perform the backup and restore operation for the MSDB.

 Q: What are the phases of Database restoring process?

A restore is a multiphase process. The possible phases of a restore include the data copy, redo (roll forward), and undo (roll back) phases:

• The data copy phase involves copying all the data, log, and index pages from the backup media of a database to the database files.
• The redo phase applies the logged transactions to the data copied from the backup to roll forward that data to the recovery point. At this point, a database typically has uncommitted transactions and is in an unusable state. In that case, an undo phase is required as part of recovering the database.
• The undo phase, which is the first part of recovery, rolls back any uncommitted transactions and makes the database available to users. After the roll back phase, subsequent backups cannot be restored.

Please visit other related articles...

https://sqldbaiq.blogspot.com/p/restoration.html
https://sqldbaiq.blogspot.com/p/restoration-part-2.html
https://sqldbaiq.blogspot.com/p/restoration-part-3.html
https://sqldbaiq.blogspot.com/p/restoration-part-4.html
https://sqldbaiq.blogspot.com/p/restoration-part-5_16.html
https://sqldbaiq.blogspot.com/p/restoration-part-6_16.html

https://sqldbaiq.blogspot.com/p/restoration-part-7.html

References: Thanks to the all the SQL Server bloggers who wrote and shared the valuable information on their blogs which helped me a lot to prepare this series of Questions. Also big thanks to Microsoft Documentation which contains each and everything about their product.