backupdatabase（backupdatabase）.docVIP

backupdatabase（backupdatabase） 2005 database backup 2010-03-06 13:10 - complete backup Backup the Database NorthwindCS G: \ Backup To disk = \ NorthwindCS_Fullbak - differential backup Backup the Database NorthwindCS G: \ Backup To disk = \ NorthwindCS_Diffbak With Differential - log backup, default truncation log Backup the Log NorthwindCS G: \ Backup To disk = \ NorthwindCS_Logbak Log backups, not truncation logs Backup the Log NorthwindCS G: \ Backup To disk = \ NorthwindCS_Logbak With No_Truncate -- truncation log is not retained Backup the Log NorthwindCS With No_Log - or Backup the Log NorthwindCS With Truncate_Only -- the log file will not shrink after truncation It is necessary to contract -- file backup Exec Sp_Helpdb NorthwindCS - view the data file Backup the Database NorthwindCS File = NorthwindCS - the logical name of the data File G: \ Backup To disk = \ NorthwindCS_Filebak -- file group backups Exec Sp_Helpdb NorthwindCS - view the data file Backup the Database NorthwindCS FileGroup = Primary - the logical name of the data file G: \ Backup To disk = \ NorthwindCS_FileGroupbak With the init - split up backup to multiple targets -- no target is allowed to be lost Backup the Database NorthwindCS G: \ Backup To disk = \ NorthwindCS_Full_1 bak G: \ Backup, disk = \ NorthwindCS_Full_2 bak -- mirror backup -- each goal is the same Backup the Database NorthwindCS G: \ Backup To disk = \ NorthwindCS_Mirror_1 bak Mirror G: \ Backup To disk = \ NorthwindCS_Mirror_2 bak With Format -- the first time you did a mirroring backup, Format the target Mirror backup to local and remote Backup the Database NorthwindCS G: \ Backup To disk = \ NorthwindCS_Mirror_1 bak Mirror Stored To disk = \ \ 192.168.1.200 \ \ NorthwindCS_Mirror_2 bak With the Format Generate a backup file every day Declare @ Path Nvarchar (2000). G: \ Backup Set @ Path = \ NorthwindCS_Full_ + the Convert (Nvarchar, Getdate (), 112) + bak Backup