RESTORE IS A MECHANISM TO RECREATE COMPLETE / PARTS OF DATABASE.
WE USE RESTORES FOR DATA RECOVERY USING AVAILABLE BACKUP FILES.
PHASES OF RESTORE:
1. COPY PHASE : Backup contents are copied to SQL Server .
2. REDO PHASE : Committed transactions from log file are issued a CHECKPOINT.
3. UNDO PHASE : Uncommitted transactions from log file are used a ROLLBACK.
SYNTAX FOR RESTORES:
RESTORE DATABASE | LOG <DBNAME>
FILE = | FILEGRUP =
FROM
DISK = <LOCATION>
WITH
RECOVERY | NORECOVERY | STANDBY | PARTIAL | REPLACE
0 comments: