c#利用代码实现数据备份数据还原

Question

要具体一点
是在visual studio中编写代码 来实现数据备份和还原

Answer 1

1.建备份设备:
use master
alter database pubs
set recovery simple
go

go
if exists(select name from sysdevices where name='DB05102FBK')
exec sp_dropdevice 'DB05102FBK'
exec sp_addumpdevice 'disk','DB05102FBK','F:\0509\Backup\DB05102FBK' --完全备份设备
go
if exists(select name from sysdevices where name='DB05102DBK')
exec sp_dropdevice 'DB05102DBK'
exec sp_addumpdevice 'disk','DB05102DBK','F:\0509\Backup\DB05102DBK' --差异备份设备
go
if exists(select name from sysdevices where name='DB05102LBK')
exec sp_dropdevice 'DB05102LBK'
exec sp_addumpdevice 'disk','DB05102LBK','F:\0509\Backup\DB05102LBK' --事务日志备份设备
go
exec sp_addumpdevice 'disk','DB05102LBK2','F:\0509\Backup\DB05102LBK2' --当前事务日志备份设备
go

可以通过上面的语句创建一个存储过程,再用C#调用存储过程就OK了.