导出数据：

-----------------------------------------------

    DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection("server = localhost;uid=sa;pwd=1qaz2wsx;database=test");
    conn.Open();
    SqlCommand comm = null;
    comm = new SqlCommand(@"SELECT * FROM person",conn);
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = comm;
    da.Fill(ds,"table");
    ds.WirteXml(@"C://a.xml",XmWriteMode.WriteSchema);

-------------------------------------------------------

　　恢复数据：

   DataSet dsEx = new DataSet();
    dsEx.ReadXml(@"c://a.xml",XmlReadMode.ReadSchema);

    foreach (DataRow d2r in ds.Tables["table"].Rows)
    {
     d2r.Delete();
    }
    da.Update(ds,"table");

    ds = dsEx.Copy();
    da.Update(ds,"table");

另一种方法 

比如备份Northwind

SQL：
backup database Northwind to disk='c:\backuptext.dat'

所以程序这样写：

string myExecuteQuery = "backup database Northwind to disk='c:\backuptext.dat'";
SqlCommand myCommand = new SqlCommand(myExecuteQuery, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();