不能备份sql数据库 [英] cant take backup of sql database

问题描述

Hii，

我不能使用以下代码备份sql数据库。请尽快帮助我。

Hii,
I can''t take backup of sql database using following code.please help me out as soon as possible.

public void BackupDatabase(String databaseName, String userName,
           String password, String serverName, String destinationPath)
       {
           try
           {
               string drop_down_value = cmbDatabase.SelectedItem.ToString();

               string con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=''" + drop_down_value + "'';Integrated Security=True;User Instance=True";

               Backup sqlBackup = new Backup();

               sqlBackup.Action = BackupActionType.Database;
               sqlBackup.BackupSetDescription = "ArchiveDataBase:" +
                                                DateTime.Now.ToShortDateString();
               sqlBackup.BackupSetName = "Archive";

               sqlBackup.Database = "event.mdf";

               BackupDeviceItem deviceItem = new BackupDeviceItem("D:\\test.bak", DeviceType.File);
               SqlConnection sqlCon = new SqlConnection(con);
               ServerConnection connection = new ServerConnection(sqlCon);
               //  ServerConnection connection = new ServerConnection(serverName, userName, password);
               Server sqlServer = new Server(connection);

               Database db = sqlServer.Databases[drop_down_value];

               sqlBackup.Initialize = true;
               sqlBackup.Checksum = true;
               sqlBackup.ContinueAfterError = true;

               sqlBackup.Devices.Add(deviceItem);
               sqlBackup.Incremental = false;

               sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
               sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;

               sqlBackup.FormatMedia = false;

               sqlBackup.SqlBackup(sqlServer);
               MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           catch (Exception ex)
           {
           }
       }

推荐答案

备份可能失败的原因有很多。

试试这个：用C＃备份SQL数据库 [ ^ ]

There are a huge number of possible reasons why a backup may fail.
Try this: Backing up an SQL Database in C#[^]

您可以轻松执行备份，如果需要在[垃圾链接删除]的帮助下恢复sql数据库



本文将帮助你实现

You may easily carry out backup and if it need restore sql database with the help of [spam link removed]

This article will help you to make it

这篇关于不能备份sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！