Database Technologies‎ > ‎MSSQL‎ > ‎

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 info
RESTORE LABELONLY  =   Media info
RESTORE REWINDONLY =   Rewind and close tape device
RESTORE VERIFYONLY  =  Verify validity of backupset


Comments