1. Recovery : This is default option, leave the database in functional state and database can be used by end users. Additional backups cannot be applied on database.
Restore database DBNAME from disk=‘Backup-device’ with recovery
Go
Restore database DBNAME from disk=‘Backup-device’ with recovery
Go
Note: If your database is in the restoring state and you want to recover it without restoring additional backups you can issue a RESTORE DATABASE WITH RECOVERY to bring the database online for users to use.
Restore database [DBNAME] with Recovery
Go
2. NORECOVERY: Additional backups can be applied on the database.it leaves the database in non-functional state, we need to apply the additional backups in order to bring the database online.
RESTORE DATABASE DBNAME FROM DISK = ‘Backup-device’
WITH NORECOVERY
GO
RESTORE LOG DBNAME FROM DISK = ‘Backup-device’
WITH RECOVERY
GO
3.STANDBY/READ-ONLY: Database will be in Read-only mode, DML operations cannot be performed on DB.Transaction Undo(.TUF) file is created which contains uncommitted transactions.
Restore database DBNAME from disk=‘Backup-device’ with File=1,
STANDBY=‘File-system-Path\Restore_RollbackUndo.tuf’, STATS=5
0 comments: