RESTORE INTERVIEW QUESTIONS

1)    What is Restore? What are the recovery states? Explain Each?

Restore means recover the data from backups. There are three recovery states for Restore.    (1) With Recovery (2) With No-Recovery (3) Standby.

a)  With Recovery:- With Recovery option the Database will comes to Online and get ready to using Database. But further backups cannot restored. Generally while restoring recent (last) T.Log we can choose WITH RECOVERY option.

b)  With No-Recovery:- With No-Recovery option the Databases will comes to restoring mode and further backups can restore, but users can’t access DB. Generally use this option for all backups (except recent log) for restore further backups.

c)   Standby:- With Standby option the Databases will comes to Restoring/Read-only mode. In this mode further (next) backups can restore, but users have read-only access DB. Generally use this option for all backups (except recent log) for restore further backups.

2)    What are the common scenarios to Restoring the Data?

1)  To restore the lost and corrupted data after a system failure

2)  To restore a database onto a development system for user by application developers while developing and testing new code.

3)  To restore a database onto a test system to load test applications and database features.

4)  To restore a database on separate server as a read-only database to perform queries for reports.

3)    In which edition On-line restoration is possible?

On-line restoration is possible only in Enterprise edition.

4)    What are the Syntaxes for Restore?

a)  With Recovery:-Restore database dbname from disk = “Path” with recovery

b)  With No-Recovery:- Restore database dbname from disk = “Path” with no recovery

c)   Standby:- Restore database dbname from disk = “Path” with no standby

5)    What is Point-in-time restore and use of that?

Point-in-time restore is used to restore the Database to a particular time just before a failure has occurred or before corrupt data.

To Restore a Database to a Point-in-time:-

STOPAT is used to restore a database to specific time.

6)    Restore Strategy?

1.     First restore recent last full backup

2.     Then restore last Diff. backup

3.     Then restore all Transaction Log backups since recent Full/Diff backups.