( 用SQL语句实现对数据库备份还原操作
备份SqlServer数据库:
backup database 数据库名 to disk (备份文件存放路径+文件名).bak
还原SqlServer数据库:
string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称
use master restore database 数据库名 from disk=’" + path + "’"; )
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;
using System.Data.Sql;
using System.IO;
namespace 数据库备份
{
public partial class Form1 : Form
{
//需要添加一个引用C:\Program Files\Microsoft SQL Server\80\Tools\Binn下的SQLDMO.DLL;
//SQL默认安装下是在以上路径
//备份的文件放在C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP下
string ServerName = "";
string UserName = "sa";//暂时锁定,可以根据需要自己设置
string Password = "sa";
public Form1()
{
InitializeComponent();
}
//获取服务器列表
public ArrayList GetServerList()
{
ArrayList alServers = new ArrayList();
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
try
{
SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();
for (int i = 1; i <= serverList.Count; i++)
{
alServers.Add(serverList.Item(i));
//comboBox1.Items.Add(serverList.Item(i));
list