求数据库备份还原代码！！

[a1015154569]

C#应用程序 SQLserver2005。 数据库名：DryClean
求数据库的备份还远代码。
急！！！

[wuyq11]

用数据库存储过程或SQLDMO实现
参考
参考

[jcyluck]

下例创建用于存放 MyNwind 数据库完整备份的逻辑备份设备。

-- Create a logical backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'

-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1



下列命令可以还原 Analysis Services 中的示例数据库 FoodMart 2000。

"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /r myserver
"\Program Files\Microsoft Analysis Services\Data\"
"\My archives\server myserver\FoodMart 2000.cab"

[FlyBee]

 public void beifenInfo()
        {
            try
            {
                sd.InitialDirectory = Application.StartupPath + "\\";//默认路径为D：//
                sd.FilterIndex = 1;								//默认值为第一个
                sd.RestoreDirectory = true;						//重新定位保存路径
                sd.Filter = "备份文件 (*.bak)|*.bak|所有文件 (*.*)|*.*";//筛选器，定义文件类型
                if (sd.ShowDialog() == DialogResult.OK)
                {
                    if (!File.Exists(sd.FileName.ToString()))
                    {
                        SqlConnection con = new SqlConnection();		//利用代码实现连接数据库
                        con.ConnectionString = "server=.;uid=sa;pwd=;database='"+this.comboBox1.Text+"'";
                        con.Open();
                        SqlCommand com = new SqlCommand();
                        this.textBox1.Text = sd.FileName.ToString();
                        com.CommandText = "BACKUP DATABASE " + this.comboBox1.Text + " TO DISK = '" + sd.FileName.ToString() + "'";
                        com.Connection = con;							//连接
                        com.ExecuteNonQuery();						    //执行
                        con.Close();
                        con.Dispose();
                        MessageBox.Show("数据备份成功！");
                    }
                    else
                    {
                        MessageBox.Show("请重新命名！");
                    }
                }
            }
            catch (Exception k)
            {
                MessageBox.Show(k.Message);
                return;
            }
        }

[dengyun_1223]

up

[周公]

SQLDMO类用于备份和恢复数据库

private void Button3_Click(object sender, System.EventArgs e)
{
    //引用SQLDMO.dll，SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供，SQLDMO.dll是一个COM对象
    SQLDMO.Backup backup=new SQLDMO.BackupClass();
    SQLDMO.SQLServer sqlserver=new SQLDMO.SQLServerClass();
    sqlserver.LoginSecure=false;
    sqlserver.Connect("localhost","sa","1");
    backup.Action=SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
    backup.Database="userdb";
    backup.Files=@"E:\Project\meng\data\userdb.bak";
    backup.BackupSetName="userdb";
    backup.BackupSetDescription="数据库备份";
    backup.Initialize=true;
    backup.SQLBackup(sqlserver);
}

private void Button4_Click(object sender, System.EventArgs e)
{
    SQLDMO.Restore restore=new SQLDMO.RestoreClass();
    SQLDMO.SQLServer sqlserver=new SQLDMO.SQLServerClass();
    sqlserver.LoginSecure=false;
    sqlserver.Connect("192.168.19.25","sa","sa");            restore.Action=SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
    restore.Database="userdb";
    restore.Files=@"E:\Project\meng\data\userdb.bak";
    restore.BackupSetName="userdb";            
    restore.FileNumber=1;
    restore.SQLRestore(sqlserver);
}

[xufzu123]

up~~

[yilanwuyu123]

备份还原我都是在数据库服务器上直接操作的。貌似显的弱了。

[boywangliang]

/// <summary>
/// 备份数据库db_member
/// </summary>
public static void BackupDataBase()
{
try
{
conn.Open();
SqlCommand Comm = new SqlCommand();
Comm.Connection = conn;
Comm.CommandText = "use master;backup database @dbname to disk = @backupname;";

Comm.Parameters.Add(new SqlParameter(@"dbname", SqlDbType.NVarChar));
Comm.Parameters[@"dbname"].Value = "db_member";
Comm.Parameters.Add(new SqlParameter(@"backupname", SqlDbType.NVarChar));
Comm.Parameters[@"backupname"].Value = @"D:\back.bak";

Comm.CommandType = CommandType.Text;
Comm.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "信息提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
conn.Close();
}
}