1。数据文件
3。for example:
backup database msdb filegroup='primary' to disk='d:\a.bkp'
3。for example:
backup database msdb filegroup='primary' to disk='d:\a.bkp'
解决方案 »
- 安装 SQL Server 2008 Developer Edition,总无法成功安装Analysis Services?
- 在线求一sql语句。。。
- [求助]如何取分组最大值的行ID或者其它信息
- 救命啊!连接数据库时为什么用机器名可以连接上去而用该机器IP连接连接不上?
- 1433 端口 无法连接
- sql中给表的的一个时间字段添加值,及时间格式问题
- 安装Reporting Service中遇到的问题,急,在线等!
- 求救:有关于 CONVERT等类型转换
- SQL Server导入数据为什么有问题?
- 如何在SQL SERVER 7。0中存储图象?
- 在线请教关于sql中的检索文本语句
- 关于存储过程组合查询得问题
< 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 ] ]
]