数据库备份恢复工具

 一下程序是用WPF实现的一个数据库备份（BackUp）与恢复（Restore）小工具。原理比较简单，使用执行Sql 脚本实现。

在回复数据库时，如果数据库真正被多人使用或者链接没有释放的情况下，我们需要先将数据库至为单用户模式,然后删除原数据库在进行恢复。

 

 

The following code shows the UI design: 

<Window x:Class="WpfApplication1.Window1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="Database BackUp and Restore" Height="213.248" Width="384.013" OverridesDefaultStyle="False" Background="Snow" Icon="/WpfApplication1;component/Icon1.ico" ResizeMode="NoResize"> <Grid Height="176.596" Width="363.188"> <Button Name="btnRestore" AllowDrop="True" HorizontalContentAlignment="Center" Margin="66.64,0,0,56" HorizontalAlignment="Left" Width="74.97" Click="btnRestore_Click" Height="28.596" VerticalAlignment="Bottom">Restore</Button> <Button Margin="147.441,0,149.94,56" Name="btnBackUp" Click="btnBackUp_Click" Height="28.596" VerticalAlignment="Bottom">BackUp</Button> <Label Height="28" HorizontalAlignment="Left" Margin="12,21.42,0,0" Name="label1" VerticalAlignment="Top" Width="120">BackUpFile:</Label> <TextBox Height="23" Margin="79,21.42,79.135,0" Name="textBox1" VerticalAlignment="Top">'C://WorkBook//MESDB_UoM.bak'</TextBox> <Button HorizontalAlignment="Right" Margin="0,0,77.469,56" Name="btnExit" Width="66.983" Click="btnExit_Click" Height="28.596" VerticalAlignment="Bottom">Exit</Button> <Label Height="28" Margin="66.64,0,77.829,22" Name="label2" VerticalAlignment="Bottom" Foreground="Red" FontWeight="Bold" FontSize="12"></Label> </Grid> </Window>

 

 The following code shows how to backup and resotre the database:

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Data.SqlClient; using System.Diagnostics; namespace WpfApplication1 { /// <summary> /// Interaction logic for Window1.xaml /// </summary> public partial class Window1 : Window { private Stopwatch swt = null; public Window1() { InitializeComponent(); } /// <summary> /// Excute the sql script /// </summary> /// <param name="sql">Sql statement</param> /// <returns></returns> public bool BackUpAndRestoreMESDB(string sql) { bool result = true; using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;Integrated Security=True")) { SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); try { cmd.ExecuteNonQuery(); } catch { result = false; } finally { conn.Close(); } } return result; } private void btnExit_Click(object sender, RoutedEventArgs e) { this.Close(); } private void btnBackUp_Click(object sender, RoutedEventArgs e) { swt = new Stopwatch(); swt.Start(); StringBuilder sb = new StringBuilder(); sb.Append("BACKUP DATABASE MESDB TO DISK = "); sb.Append(this.textBox1.Text.Trim()); if (BackUpAndRestoreMESDB(sb.ToString())) { swt.Stop(); this.label2.Content = "it was spent " + swt.Elapsed.Seconds.ToString() + "seconds"; } } private void btnRestore_Click(object sender, RoutedEventArgs e) { swt = new Stopwatch(); swt.Start(); StringBuilder sb = new StringBuilder(); sb.Append("ALTER DATABASE MESDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;"); sb.Append("DROP DATABASE MESDB;"); sb.Append("RESTORE DATABASE MESDB FROM DISK = "); sb.Append(this.textBox1.Text.Trim()); if (BackUpAndRestoreMESDB(sb.ToString())) { swt.Stop(); this.label2.Content = "it was spent " + swt.Elapsed.Seconds.ToString() + "seconds"; } } } }