.NET备份数据库并压缩并查看已有备份

最新推荐文章于 2024-07-09 16:12:08 发布

绿绦

最新推荐文章于 2024-07-09 16:12:08 发布

阅读量105

点赞数

分类专栏：基础文章标签： .net ASP.net UI ASP JavaScript ViewUI

基础专栏收录该内容

8 篇文章 0 订阅

订阅专栏

对数据库的备份和压缩操作等功能全部集成在一起被能够查看已经备份并压缩好的文件

这是数据库备份的展示页面代码如下：

BackUp.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BackUp.aspx.cs" Inherits="Crm.Pages.Pages_CRM_BackUp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>数据库备份</title>

</head>

<div>

<td align="left"><span style="display:inline-block;margin-left:8px"><span><img src="../Tcps/Images/localGIF.gif" width="17" height="17" align="absmiddle" style="border-width:0px;" /> 您现在的位置：</span> 管理页面>>> 数据库备份</span></td>

</tr>

</table>

<br />

<div>

<br />

<asp:Button ID="Button1" CssClass="Button_6" runat="server" Text="现在备份" OnClick="Button1_Click" />

<asp:Button ID="Button2" CssClass="Button_6" runat="server" Text="查看备份文件" OnClick="Button2_Click" /><br />

</div>

</td>

</tr>

<tr>

<br />

</div>

</td>

</tr>

</table>

</div>

</body>

</html>

Cs代码文件如下：

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Collections.Generic;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.IO;

using Model;

using System.Runtime.InteropServices;

using Microsoft.Win32;

using System.Diagnostics;

namespace Crm.Pages

{

/// <summary>

/// Explain:MCCS数据库备份

///2008-9-8 zcy

/// </summary>

public partial class Pages_CRM_BackUp : System.Web.UI.Page

{

private string page_id = "242";

protected void Page_Load(object sender, EventArgs e)

{

MyPages.Load(this, this.page_id, (List<string>)Session["QX_List"]);

}

/// <summary>

/// 备份

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void Button1_Click(object sender, EventArgs e)

{

//AppSettingsReader ap = new AppSettingsReader();

//string SqlStr1 = ap.("FAMConnectionString", String);

SqlConnection con = DBCOM.DBCom.getconn();//获取连接对象的方法

//sqlpath

string sqlpath = ConfigurationSettings.AppSettings["sqlpath"];

string sqlpath2 = ConfigurationSettings.AppSettings["sqlpath2"];

string name_sqlfile = DateTime.Now.ToString("yyyyMMddHHmmss") ;//名称

string path = sqlpath +"/"+ name_sqlfile+ ".dat";

string sqlurl = ConfigurationSettings.AppSettings["sqlurl"];//数据库服务器地址

// com.CommandText = "BACKUP DATABASE " + textBox1.Text + " TO DISK = '" + textBox2.Text.ToString() + "'";

// string SqlStr2 = "use master restore database FAM from disk='" + path + "'";

SqlCommand com = new SqlCommand("BACKUP DATABASE newsystem TO DISK = '" + path + "'", con);

con.Open();

com.ExecuteNonQuery();

con.Close();

//con.Dispose();

Response.Write(@"<script type='text/javascript'>alert('数据备份成功')</script>");

压缩

string savePath = Server.MapPath(ConfigurationSettings.AppSettings["savePath"]);

String the_rar;

RegistryKey the_Reg;

Object the_Obj;

String the_Info;

ProcessStartInfo the_StartInfo;

Process the_Process;

try

{

the_Reg = Registry.ClassesRoot.OpenSubKey(@"Applications\WinRAR.exe\Shell\Open\Command");

the_Obj = the_Reg.GetValue("");

the_rar = the_Obj.ToString();

the_Reg.Close();

the_rar = the_rar.Substring(1, the_rar.Length - 7);

the_Info = " a " + name_sqlfile + ".rar " + sqlurl + sqlpath2 + name_sqlfile + ".dat";

the_StartInfo = new ProcessStartInfo();

the_StartInfo.FileName = the_rar;

the_StartInfo.Arguments = the_Info;

the_StartInfo.WindowStyle = ProcessWindowStyle.Hidden;

the_StartInfo.WorkingDirectory = savePath;//获取或设置要启动的进程的初始目录。

the_Process = new Process();

the_Process.StartInfo = the_StartInfo;

the_Process.Start();

if (the_Process.WaitForExit(1000))

{

the_Process.Close();

the_Process.Dispose();

}

Response.Write(@"<script type='text/javascript'>alert('压缩成功')</script>");

}

catch (Exception ex)

{

Response.Write(@"<script type='text/javascript'>alert('" + ex.ToString() + "')</script>");

}

/// <summary>

///

/// </summary>

public void showUpDFateFile()

{

string rarName = "";

string filePathAndName = "";

string savePath = Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["savePath"]);

updatefile.Controls.Clear();

Label lbbbb = null;

if (System.IO.Directory.Exists(savePath))

{

string[] ff = Directory.GetFiles(savePath);

if (null == ff || ff.Length == 0)

{

lbbbb = new System.Web.UI.WebControls.Label();

lbbbb.Text = "<br />没有备份文件<br /> ";

//lbbbb.Text = savePath.ToString();

updatefile.Controls.Add(lbbbb);

}

foreach (string file in ff)

{

HtmlAnchor a = new HtmlAnchor();

a.HRef = file;

a.InnerHtml = file;

a.Target = "_blank";

updatefile.Controls.Add(a);

lbbbb = new System.Web.UI.WebControls.Label();

lbbbb.Text = "<br />";

updatefile.Controls.Add(lbbbb);

}

else

{

lbbbb = new System.Web.UI.WebControls.Label();

lbbbb.Text = "<br />没有备份文件<br /> ";

lbbbb.Text = savePath.ToString();

updatefile.Controls.Add(lbbbb);

}

protected void Button2_Click(object sender, EventArgs e)

{

showUpDFateFile();

}

里面的功能都已经齐全如果本服务器可以将某些路径写死上面的部分路径和变量都有说明

如不清楚请留言或登录 http://www.lvtaostudio.com查看和留言

绿绦

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
.NET备份数据库并压缩并查看已有备份

对数据库的备份和压缩操作等功能全部集成在一起被能够查看已经备份并压缩好的文件这是数据库备份的展示页面代码如下：BackUp.aspx&lt;%@ Page Language="C#" AutoEventWireup="true" CodeFile="BackUp.aspx.cs" Inherits="Crm.Pages.Pages_CRM_BackUp" %&gt;&l...
复制链接

扫一扫