备份我的ASPNETDB

Question

我想备份我的数据库，但是我得到了一个错误：

无法打开登录请求的数据库"ASPNETDB“。登录失败。用户“My-膝上型电脑\ user”登录失败。

我正在使用

以下是我备份DB的代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class Default2 : System.Web.UI.Page
{
    //Metioned here your database name
    string dbname = "ASPNETDB";
    SqlConnection sqlcon = new SqlConnection();
    SqlCommand sqlcmd = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataTable dt = new DataTable();

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        //Mentioned Connection string make sure that user id and password sufficient previlages
        sqlcon.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.mdf;Integrated Security=True;User Instance=True;Database=ASPNETDB";
        //Enter destination directory where backup file stored
        string destdir = "D:\\backupdb";

        //Check that directory already there otherwise create 
        if (!System.IO.Directory.Exists(destdir))
        {
            System.IO.Directory.CreateDirectory("D:\\backupdb");
        }
        try
        {
            //Open connection
            sqlcon.Open();
            //query to take backup database
            sqlcmd = new SqlCommand("backup database ASPNETDB to disk='" + destdir + "\\hallo1.Bak'", sqlcon);
            sqlcmd.ExecuteNonQuery();
            //Close connection
            sqlcon.Close();
            Response.Write("Backup database successfully");
        }
        catch (Exception ex)
        {
            Label1.Text = ex.Message;
            Response.Write("Error During backup database!");
        }
    }
}

Answer 1

问题是:无法备份与连接字符串中的AttachDbFileName=属性一起使用的Server数据库：

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.mdf;
Integrated Security=True;User Instance=True;Database=ASPNETDB";

如果要使用SMO备份数据库，则必须将数据库附加到要备份的Server实例。