关于.net数据库备份与还原的问题

[zhangsuyunpk521]

完全备份
try
{

string backupFolder =Server.MapPath( "~/database");
if (!System.IO.Directory.Exists(backupFolder))//判断文件夹是否存在
{
//创建文件夹
System.IO.Directory.CreateDirectory(backupFolder);
}
string backupFileName = System.IO.Path.Combine(backupFolder, DateTime.Today.ToString("yyyyMMdd.bak"));

string sqltxt = string.Format("backup database sq_shchangqie to disk='"+backupFolder+"\\"+ DateTime.Today.ToString("yyyyMMdd.bak") + "", backupFileName);

conn = new SqlConnection("server=.;uid=sa;pwd=;database=sq_shchangqie");
SqlCommand cmd = new SqlCommand(sqltxt, conn);
conn.Open();
Response.Write(conn.State.ToString());
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script>alert('成功')</script>");

}
catch (Exception ex)
{
Response.Write("<script>alert('"+ex.Message+"')</script>");

}

还原的时候如果同样用sql语句
restore database sq_shchangqie from disk='D:\ls\sq_shchangqie.bak'
来还原是不行的，因为你本来就需要连接当前数据库，所以还原会失败，哪个高手做过数据库的备份与还原的给我贴下源码，或者发到我的信箱[e-mail]里，谢谢，在线等待！~~~~~
WITH REPLACE

[tanfe12]

备份就是将原来的和数据库文件复制一份 到你的备份文件夹下
还原就是将你的备份文件夹下的数据库文件 复制一份到你的数据库文件夹下覆盖原来的

[wuyq11]

http://topic.csdn.net/u/20100514/14/c3fa2fc1-08fb-40ea-a3b3-8d169871820d.html