备份问题

SQLDMO.Backup myBackUp = new SQLDMO.BackupClass();
                    SQLDMO.SQLServer mySQlServer = new SQLDMO.SQLServerClass();
                    mySQlServer.LoginSecure = false;
                    mySQlServer.Connect(DBHelper.Connection.DataSource, "sa", "000000");
                    myBackUp.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
                    myBackUp.Database = "jxcDB";
                    myBackUp.Files = @"D:\beifen";
                    myBackUp.BackupSetName = "jxcDB";
                    myBackUp.BackupSetDescription = "数据库备份";
                    myBackUp.Initialize = true;
                    myBackUp.SQLBackup(mySQlServer);

在d:\beifen下没有备份的数据库，代码执行正确 --------------------编程问答-------------------- myBackUp.Files = @"D:\beifen";
=======
myBackUp.Files = @"D:\beifen\jxcDB.bak";



   string path=@"c:\Test.bak";

        string backupstr="backup database Test to disk='"+path+"';";

        SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;");

        SqlCommand cmd = new SqlCommand(backupstr, con);

        try

        {

            con.Open();

            cmd.ExecuteNonQuery();

            this.Label1.Text = "备份成功!";



        }

        catch

        {

            this.Label1.Text = "备份失败!";

        }

        finally

        {

            con.Close();

        }

--------------------编程问答-------------------- SQLDMO.Backup backup = new SQLDMO.BackupClass();
            SQLDMO.SQLServer sqlserver = new SQLDMO.SQLServerClass();
            sqlserver.LoginSecure = false;
            sqlserver.Connect("", "sa", "");
            backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
            backup.Database = "bingku";
            backup.Files = @"E:\data\test.bak";
            backup.BackupSetName = "test";
            backup.BackupSetDescription = "数据库备份";
            backup.Initialize = true;
            backup.SQLBackup(sqlserver);
backup database TEST to disk='d:\bakfilename.bak'
查询分析器执行
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "BACKUP DATABASE TEST TO DISK ='" + FileName+ "'";
--------------------编程问答-------------------- 1楼的哥们这里备份是备到服务器上还是本地了啊 --------------------编程问答-------------------- 程序在哪运行就备份在哪
在本机运行就备份到本机
在服务器上运行就备份到服务器

补充：.NET技术 ,  ASP.NET