Backup & Restore

Full Backup : Backs up entire database and enough of the

transaction log to provide recovery

Differential : Backs up everything changed after full backup.

Transaction : Backs up everything after last backup

.........../Updation in progress

restore database <Database Name> from disk ='<Path to backup file>'

with move '<logical Name>' to '<physical Path>',

move '<logical Name>' to '<physical Path>',

move '<logical Name>' to '<physical Path>',

move '<logical Name>' to '<physical Path>',

standby='<Path to TUF file>',replace,stats=10

restore log <Database Name> from disk='<Path to Log backup file>'

with standby='<Path to TUF file>'

restore database <Database Name> with recovery

=

RESTORE FILELISTONLY = List data/log files)RESTORE HEADERONLY = List backup header infoRESTORE LABELONLY = Media infoRESTORE REWINDONLY = Rewind and close tape deviceRESTORE VERIFYONLY = Verify validity of backupset