sql server备份与还原 sql语句
USE master DECLARE tb CURSOR LOCAL FOR SELECT 'Kill '+ CAST(Spid AS VARCHAR) FROM master.dbo.sysprocesses
WHERE dbid=DB_ID('E9_JinShi') DECLARE @s nvarchar(1000) OPEN tb FETCH tb INTO @s
WHILE @@FETCH_STATUS = 0 BEGIN EXEC (@s) FETCH tb INTO @s END CLOSE tb DEALLOCATE tb
RESTORE DATABASE E9_JinShi FROM disk='C:\Documents and Settings\Administrator\桌面\E39_JINSHI_20140310.bak'
WITH MOVE 'HIDEAEMS_V2006_Data' TO 'F:\DB\FDBEO_Jinshi\E9_JinShi_Data.MDF',
MOVE 'HIDEAEMS_V2006_Log' TO 'F:\DB\FDBEO_Jinshi\E9_JinShi_log.ldf',
STATS = 10, REPLACE
数据还原
SqlConnection conn = new SqlConnection(ConnectionString);
if (this.txtPlace.Text != "")
{
try
{
string P_Str_cmdtxt = "USE master DECLARE tb CURSOR LOCAL FOR SELECT 'Kill '+ CAST(Spid AS VARCHAR) FROM master.dbo.sysprocesses";
P_Str_cmdtxt += " WHERE dbid=DB_ID('db_GoodsManage') DECLARE @s nvarchar(1000) OPEN tb FETCH tb INTO @s";
P_Str_cmdtxt += " WHILE @@FETCH_STATUS = 0 BEGIN EXEC (@s) FETCH tb INTO @s END CLOSE tb DEALLOCATE tb";
P_Str_cmdtxt += " RESTORE DATABASE db_GoodsManage FROM disk='" + txtPlace.Text.Trim() + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(P_Str_cmdtxt, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("数据还原成功");
}
catch
{
MessageBox.Show("数据还原失败");
return;
}
finally
{
conn.Close();
}
数据同步
SqlConnection conn = new SqlConnection(ConnectionString);
try
{
if ((txtPlace.Text.Trim() != "") && (txtBakName.Text.Trim() != ""))
{
string cmdtxt = "backup database db_GoodsManage to disk='" + txtPlace.Text.Trim() + "\\" + txtBakName.Text.Trim()+ ".bak'";
conn.Open();
SqlCommand cmd = new SqlCommand(cmdtxt,conn);
cmd.ExecuteNonQuery();
MessageBox.Show("备份成功");
return;
}
else
{
MessageBox.Show("备份失败");
return;
}
}
catch(Exception ee)
{
MessageBox.Show("备份失败"+ee.ToString());
return;
}
finally
{
conn.Close();
}
最新文章
- [大数据之Spark]——Actions算子操作入门实例
- SpringBoot整合MyBatis
- 【荐2】Total Commander 7.57 配置选项 个性化设置备份,,,开启时如何自动最大化???(二)
- dsoframer控件学习小结(打开WORD,EXCEL等文件)
- 限制页面内部链接访问源-HTML注释
- RHEL(RedHat Enterprise Linux)5/6 ISO镜像下载
- JQuery设置input属性(disabled、enabled)
- (转)[老老实实学WCF] 第一篇 Hello WCF
- python爬虫数据抓取方法汇总
- 马踏棋盘问题-贪心(MATLAB&;C++)
- Codeforces Round#297 div2
- Android Studio的使用(十四)--如何查看资源或者函数在哪些类中被引用
- 老李分享:《Linux Shell脚本攻略》 要点(三)
- angular2 表单验证
- shell的date
- POJ 1015 Jury Compromise(双塔dp)
- 30. Spring Boot ActiveMQ
- [转]启动tensorboard
- 如何使用Ubuntu中的avdManager命令行为“System-Image;Androd-27;GoogleAPI;x86”创建一个AVD?
- 用Lua实现string的trim()方法