我们如何从C＃中备份SQL [英] How we can take back up of SQL from C#

问题描述

我有一个表单，我的表单中有两个Button用于选择文件夹，第二个用于备份数据库，当前用于我的项目我希望在备份按钮单击时备份我的数据库。

并且还使用C＃恢复数据库＃

任何人帮助我。

我正在尝试此代码按钮我面临错误。

先谢谢。



错误

system.sql.sqlclint.sqlexception：无法打开备份设备。

操作系统错误。访问被拒绝。

备份数据库异常终止



我尝试过：

i have a form and there is two Button in my form one for Select Folder and 2nd for take back up of database which is currently used for my project i want to take backup of my database on backup button click.
and also take Restore database using C#
Any One Help me.
I'm trying this code button i am facing error.
Thanks in Advance.

error is
system.sql.sqlclint.sqlexception:Cannot open Backup device.
operating system error. access denied.
Backup database terminating abnormally

What I have tried:

using (SqlConnection conn4 = new SqlConnection(DbConfigClass.connectDb()))
            {
                string database = conn4.Database.ToString();
                try
                {
                    if (PathtextBox.Text == string.Empty)
                    {

                    }
                    else
                    {                       
                        string cmd = "BACKUP DATABASE ["+database+"] TO DISK '"+PathtextBox.Text+"\\"+"Database"+"-"+DateTime.Now.Ticks.ToString("yyyy-MM-dd--HH-mm-ss")+ ".back'";
                        using (SqlCommand comand = new SqlCommand(cmd, conn4))
                        {
                            if (conn4.State != ConnectionState.Open)
                            {
                                conn4.Open();
                            }
                            comand.ExecuteNonQuery();
                            conn4.Close();
                            MessageBoxClass.ShowSucessMessage("Successful to backup data","Successful");
                        }
                    }
                }
                catch (Exception es)
                {
                    MessageBoxClass.ShowErrorMessage("" + es, "");
                }
            }

推荐答案

请参阅此处：用C＃备份SQL数据库 [ ^ ]

这篇关于我们如何从C＃中备份SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！