急急！---数据库备份怎么实现在C#中

[yuzhongnanhai]

怎样用c#语言来实现sql server 2000数据库的备份!
谢谢！！！！！1

[oolongTea]

http://community.csdn.net/Expert/TopicView3.asp?id=4749663

[cjnet]

用SQL寫個存儲過程來執行存儲操作啊

[syeerzy]

对C#来说...数据库备份和 SELECT * FROM Table1 没什么不一样的.

完全一样.(如果你的数据库用户有备份数据库的权限的话)

[syeerzy]

Sql语句不一样而已,这已经不是C#的内容了.

把SELECT语句换成

BACKUP DATABASE 数据库名 TO 备份设备名

而已

[syeerzy]

上面是完全备份.

完整备份语法:

BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ [ MIRROR TO < backup_device > [ ,...n ] ] [ ...next-mirror ] ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] { CHECKSUM | NO_CHECKSUM } ]
[ [ , ] { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] { FORMAT | NOFORMAT } ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
[ [ , ] COPY_ONLY ]
]