SQL SERVER 数据库备份的三种策略及语句

Sql语句：

BACKUP LOG [wxh] TO DISK = N'C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupwxh.bak' WITH NOFORMAT, NOINIT, NAME = N'wxh-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

4.增量数据备份与日志备份相结合

sql语句：

备份整个数据库：
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,…n ]
[ WITH
    [ BLOCKSIZE = { blocksize | @blocksize_variable } ]    [ [ , ] DESCRIPTION = { ‘text’ | @text_variable } ]    [ [ , ] DIFFERENTIAL ]    [ [ , ] EXPIREDATE = { date | @date_var }
        | RETAINDAYS = { days | @days_var } ]    [ [ , ] PASSWORD = { password | @password_variable } ]    [ [ , ] FORMAT | NOFORMAT ]    [ [ , ] { INIT | NOINIT } ]    [ [ , ] MEDIADESCRIPTION = { ‘text’ | @text_variable } ]    [ [ , ] MEDIANAME = { media_name | @media_name_variable } ]    [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]    [ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]    [ [ , ] { NOSKIP | SKIP } ]    [ [ , ] { NOREWIND | REWIND } ]    [ [ , ] { NOUNLOAD | UNLOAD } ]    [ [ , ] RESTART ]    [ [ , ] STATS [ = percentage ] ]
]备份特定的文件或文件组：
BACKUP DATABASE { database_name | @database_name_var }
    < file_or_filegroup > [ ,…n ]
TO < backup_device > [ ,…n ]
[ WITH
    [ BLOCKSIZE = { blocksize | @blocksize_variable } ]    [ [ , ] DESCRIPTION = { ‘text’ | @text_variable } ]    [ [ , ] DIFFERENTIAL ]    [ [ , ] EXPIREDATE = { date | @date_var }
        | RETAINDAYS = { days | @days_var } ]    [ [ , ] PASSWORD = { password | @password_variable } ]    [ [ , ] FORMAT | NOFORMAT ]    [ [ , ] { INIT | NOINIT } ]    [ [ , ] MEDIADESCRIPTION = { ‘text’ | @text_variable } ]    [ [ , ] MEDIANAME = { media_name | @media_name_variable } ]    [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]    [ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]    [ [ , ] { NOSKIP | SKIP } ]    [ [ , ] { NOREWIND | REWIND } ]    [ [ , ] { NOUNLOAD | UNLOAD } ]    [ [ , ] RESTART ]    [ [ , ] STATS [ = percentage ] ]
]备份一个事务日志：
BACKUP LOG { database_name | @database_name_var }
{     TO < backup_device > [ ,…n ]    [ WITH