.NET备份数据库并压缩并查看已有备份_数据库备份怎么看压缩备份没-CSDN博客

本文链接：https://blog.csdn.net/wumingwei_123/article/details/4305363

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

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

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 查看和留言

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

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