用C#备份与恢复数据库
来源:互联网 发布:python queue.empty 编辑:程序博客网 时间:2024/05/20 04:11
SqlConnection conn = new SqlConnection(StrConn) //StrConn 为数据库连接字符串
conn.Open();
//备份
string strSQL =@"use +DataBase+@" //DataBase为数据库名
declare @sql nvarchar(2000),
declare @aa nvarchar(20),
declare @filename varchar(200),
declare @par nvarchar(1000)
set @aa = '"+DataBase+@'"
set @filename ='"+StrBackupFile+@"' //StrBackupFile为备份文件名
select @par ='@filename varchar(1000)'
select @sql ='BACKUP DATEBASE' +@aa+ 'to disk=@filename with format'
execute sp_executesql @sql,@par,@filename ";
//恢复
string StrSQL =@"declare @backuppath varchar(200)
set @backuppath = '"+strBackupFile+@"' //strBackupFile为备份好的数据库文件
declare @installpath(200)
execute master.dbo.ex_regread 'HKEY_LOCAL_MACHINE','SOFTWARE/Microsoft/NSSQLSERVER/SETUP','SQLPATH',@installpath output
set @installpath =@installpath+'/data/'
declare @minstallpath varchar(100)
declare @linstallpath varchar(100)
set @minstallpath =@installpath+"+strDbName+"+@".mdf"//strDbName为数据库名
set @linstallpath =@installpath+"+strDbName+"+@".ldf"//strDbName为数据库名
restore database "+@strDbName+@" from disk =@backuppath
with move "+strDbName+@" to @minstallpath
move "+strDbName+@"+@"_log" to @linstallpath
replace";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.CommandTimeout =300;
cmd.ExecuteNoQuery();
conn.close();
/**********/
http://blog.csdn.net/zhr_jerry/archive/2007/08/03/1723731.aspx
/**********/
conn.Open();
//备份
string strSQL =@"use +DataBase+@" //DataBase为数据库名
declare @sql nvarchar(2000),
declare @aa nvarchar(20),
declare @filename varchar(200),
declare @par nvarchar(1000)
set @aa = '"+DataBase+@'"
set @filename ='"+StrBackupFile+@"' //StrBackupFile为备份文件名
select @par ='@filename varchar(1000)'
select @sql ='BACKUP DATEBASE' +@aa+ 'to disk=@filename with format'
execute sp_executesql @sql,@par,@filename ";
//恢复
string StrSQL =@"declare @backuppath varchar(200)
set @backuppath = '"+strBackupFile+@"' //strBackupFile为备份好的数据库文件
declare @installpath(200)
execute master.dbo.ex_regread 'HKEY_LOCAL_MACHINE','SOFTWARE/Microsoft/NSSQLSERVER/SETUP','SQLPATH',@installpath output
set @installpath =@installpath+'/data/'
declare @minstallpath varchar(100)
declare @linstallpath varchar(100)
set @minstallpath =@installpath+"+strDbName+"+@".mdf"//strDbName为数据库名
set @linstallpath =@installpath+"+strDbName+"+@".ldf"//strDbName为数据库名
restore database "+@strDbName+@" from disk =@backuppath
with move "+strDbName+@" to @minstallpath
move "+strDbName+@"+@"_log" to @linstallpath
replace";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.CommandTimeout =300;
cmd.ExecuteNoQuery();
conn.close();
/**********/
http://blog.csdn.net/zhr_jerry/archive/2007/08/03/1723731.aspx
/**********/
- 用C#备份与恢复数据库
- c#数据库备份与恢复
- C#实现SQL数据库备份与恢复
- C# winfrom数据库备份与恢复
- C#实现SQL数据库备份与恢复
- C#数据库备份恢复
- C#数据库备份恢复
- C#数据库备份恢复
- C#备份、恢复数据库
- 数据库备份与恢复
- 数据库备份与恢复
- 备份与恢复数据库
- 数据库备份与恢复
- 数据库备份与恢复
- 数据库备份与恢复
- 数据库备份与恢复
- 数据库备份与恢复
- 数据库备份与恢复
- jsp 中获得浏览器,操作系统等型号问题
- 打包目录成 jar
- 完全背包问题(Java实现)
- 禁掉WINDOWS文件保护(WFP)
- 怎样生成CAB
- 用C#备份与恢复数据库
- MII接口详解
- Scott Guthrie 博客中文版
- Mysql数据库基本操作概要
- socket阻塞式和非阻塞式通信
- MyEclipse万能注册
- 在xp sp2上部署asp.net3.5的问题
- 大猫咪头像,我的新头像
- CAS 配置使用方法