数据库的备份
来源:互联网 发布:企业淘宝开店流程步骤 编辑:程序博客网 时间:2024/06/11 17:41
这是学长写的数据库备份 我还没完全理解 先贴上
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data;using System.Data.Sql;using System.Data.SqlClient;namespace DAL{ public class BackUpDAL { public SqlConnection conn = null; //public SqlConnection connmaster = null; public SqlCommand cmd = null; //public SqlCommand cmdmaster = null; public BackUpDAL() { conn = new SqlConnection(@"server=.;DataBase=JZT_SignUp;uid=sa;pwd=123456"); cmd = new SqlCommand(); cmd.Connection = conn; } //备份数据库 public bool BackUp() { try { conn.Close(); conn.Open(); string path = "D:\\Back\\JZT_SignUp.bak"; string strsql = @"use master;backup database JZT_SignUp to disk =N" + "'" + path + "'" + "with format "; cmd = new SqlCommand(strsql, conn); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception e) { return false; } return true; } //还原数据库 public bool RoolBack() { //更换连接 conn = new SqlConnection(@"server=.;database=master;uid=sa;pwd=123456"); //关闭当前数据库 string closestr = "alter database [JZT_SignUp] set offline with rollback immediate";//先关闭数据库 cmd.Connection = conn; conn.Close(); conn.Open(); cmd = new SqlCommand(closestr, conn); cmd.ExecuteNonQuery(); conn.Close(); string path = "D:\\Back\\JZT_SignUp.bak";//源路径 string mdfsavepath = "D:\\Back1\\JZT_SignUp.mdf"; string logsavepath = "D:\\Back1\\JZT_SignUp.log"; //string strsql = "restore database JZT_SignUp from disk= N'D:\\Back\\JZT_SignUp.bak' WITH MOVE JZT_SignUp to N'D:\\Back1\\JZT_SignUp.mdf' MOVE JZT_SignUp_Log to N'D:\\Back1\\JZT_SignUp.log'"; string strsql = @"restore database JZT_SignUp from disk=N" + "'" + path + "'"; strsql += "With Move 'JZT_SignUp' to N" + "'" + mdfsavepath + "'"+","; strsql += "MOVE 'JZT_SignUp_log' to N" + "'" + logsavepath + "',REPLACE,recovery"; try { conn.Close(); conn.Open(); cmd = new SqlCommand(strsql, conn); cmd.ExecuteNonQuery(); conn.Close(); //打开,继续使用 string openstr = "alter database [JZT_SignUp] set online";//再打开数据库 conn.Open(); cmd = new SqlCommand(openstr, conn); cmd.ExecuteNonQuery(); conn.Close(); conn = new SqlConnection(@"server=.;database=master;uid=sa;pwd=123456"); } catch(Exception e) { return false; } return true; } }}
阅读全文
0 0
- Oracle数据库的备份
- 数据库备份的种类
- 数据库备份的种类
- Oracle数据库的备份
- 数据库的备份
- 数据库的备份语句
- 数据库备份的种类
- DB2数据库的备份
- 备份数据库的脚本
- 数据库的备份
- 数据库的备份
- 数据库的备份
- BERT数据库的备份
- BERT数据库的备份
- 数据库备份的种类
- 数据库的备份脚本
- 数据库备份的校验
- 数据库的自动备份
- CaptureMouse/CaptureStylus 可能会失败
- "=="和equals方法究竟有什么区别?
- day01
- java数组
- RxJava:walfud 彻底搞懂 RxJava 系列 笔记
- 数据库的备份
- XSSFSheet对象使用getLastRowNum()方法/合并单元格
- 阿尔法元秒杀阿法狗,人工智能时代开启了吗
- 计算机网络原理
- scrollview嵌套listview导致的高度计算不正确
- ar
- 多线程基础
- day02
- 机器学习笔记:数据处理基础