Code Backup và Restore database SQL bằng C#

Giả sử mình đã tạo form Backup dữ liệu. Dưới đây là code của nút Backup

private void btnBackUp_Click(object sender, EventArgs e)

        {

            bool bBackUpStatus = true;

            Cursor.Current = Cursors.WaitCursor;

            if (Directory.Exists(@"c:\SQLBackup"))

            {

                if (File.Exists(@"c:\SQLBackup\wcBackUp1.bak"))

                {

                    if (MessageBox.Show(@"Do you want to replace it?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)

                    {

                        File.Delete(@"c:\SQLBackup\wcBackUp1.bak");

                    }

                    else

                        bBackUpStatus = false;

                }

            }

            else

                Directory.CreateDirectory(@"c:\SQLBackup");

            if (bFileStatus)

            {

                //Connect to DB

                SqlConnection connect;

                string con = "Data Source = localhost; Initial Catalog=dbWiseCodes ;Integrated Security = True;";

                connect = new SqlConnection(con);

                connect.Open();

                //----------------------------------------------------------------------------------------------------

                //Execute SQL---------------

                SqlCommand command;

                command = new SqlCommand(@"backup database dbWiseCodes to disk ='c:\SQLBackup\wcBackUp1.bak' with init,stats=10", connect);

                command.ExecuteNonQuery();

                //-------------------------------------------------------------------------------------------------------------------------------

                connect.Close();

                MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

        }

Giả sử mình đã tạo form Restore dữ liệu. Dưới đây là code của nút Restore

private void btnRestore_Click(object sender, EventArgs e)

        {

            Cursor.Current = Cursors.WaitCursor;

            try

            {

                if (File.Exists(@"c:\SQLBackup\wcBackUp1.bak"))

                {

                    if (MessageBox.Show("Are you sure you restore?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)

                    {

                        //Connect SQL-----------

                        SqlConnection connect;

                        string con = "Data Source = localhost; Initial Catalog=master ;Integrated Security = True;";

                        connect = new SqlConnection(con);

                        connect.Open();

                        //-----------------------------------------------------------------------------------------

                        //Excute SQL----------------

                        SqlCommand command;

                        command = new SqlCommand("use master", connect);

                        command.ExecuteNonQuery();

                        command = new SqlCommand(@"restore database dbWiseCodes01 from disk = 'c:\SQLBackup\wcBackUp1.bak'", connect);

                        command.ExecuteNonQuery();

                        //--------------------------------------------------------------------------------------------------------

                        connect.Close();

                        MessageBox.Show("Has been restored database", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    }

                }

                else

                    MessageBox.Show(@"Do not make any endorsement above (or is not in the correct path)", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception exp)

            {

                MessageBox.Show(exp.Message);

            }

        }

Lưu ý: -c:\SQLBackup\wcBackUp1.bak: đường dẫn file backup

       -dbWiseCodes: Tên database