以下是本人ＱＱ空间早期日记. 都是自己实际工作中用到的（分享一下）

第一种：　网页版.这个手动备份的．

1. using (SqlConnection conn = new SqlConnection(cn))
   
2. {
   
3. conn.Open();
   
4. string sql1 = "DUMP TRANSACTION code WITH NO_LOG";
   
5. string sql11 = "BACKUP LOG code WITH NO_LOG";
   
6. string sql2 = "DUMP TRANSACTION code WITH NO_LOG";
   
7. string sql22 = "BACKUP LOG code WITH NO_LOG";
   
8. using (SqlCommand cmd = new SqlCommand(sql1, conn))
   
9. {
   
10. cmd.ExecuteNonQuery();
    
11. }
    
12. using (SqlCommand cmd = new SqlCommand(sql11, conn))
    
13. {
    
14. cmd.ExecuteNonQuery();
    
15. }
    
16. using (SqlCommand cmd = new SqlCommand("update zhiyuan set sb='..',linkzt='..'", conn))
    
17. {
    
18. cmd.ExecuteNonQuery();
    
19. }
    
20. using (SqlCommand cmd = new SqlCommand(sql2, conn))
    
21. {
    
22. cmd.ExecuteNonQuery();
    
23. }
    
24. using (SqlCommand cmd = new SqlCommand(sql22, conn))
    
25. {
    
26. cmd.ExecuteNonQuery();
    
27. }
    
28. 
    
29. }
    
30. try
    
31. {
    
32. if (File.Exists(Server.MapPath("xx.rar")))
    
33. {
    
34. File.Delete(Server.MapPath("xx.rar"));
    
35. }
    
36. // System.IO.StreamWriter s = new StreamWriter((System.IO.Stream)File.OpenWrite(MapPath("link.rar")));
    
37. }
    
38. catch (Exception ex)
    
39. { }
    
40. SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
    
41. SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
    
42. try
    
43. {
    
44. oSQLServer.LoginSecure = false;
    
45. oSQLServer.Connect("IP", "sa", "密码");
    
46. oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
    
47. oBackup.Database = "数据库";
    
48. oBackup.Files = "[" + MapPath("xx.rar") + "]";
    
49. oBackup.BackupSetName = "xx";
    
50. oBackup.BackupSetDescription = "数据库备份";
    
51. oBackup.Initialize = true;
    
52. oBackup.SQLBackup(oSQLServer);
    
53. ClientScript.RegisterStartupScript(this.GetType(), "m2", "<script>alert('备份成功')</script>");
    
54. 
    
55. }
    
56. catch (Exception exx)
    
57. {
    
58. ClientScript.RegisterStartupScript(this.GetType(), "m2", "<script>alert('备份失败')</script>");
    
59. }
    
60. 
    

复制代码

第二种:服务器版　在sql server 代理中．作业里

1. DUMP TRANSACTION link WITH NO_LOG
   
2. 
   
3. 
   
4. 
   
5. BACKUP LOG link WITH NO_LOG
   
6. 
   
7. DECLARE @Num varchar(50)
   
8. 
   
9. SET @Num = 'D:\bak\'+ convert(varchar(50),getdate(),5)+'.bak'
   
10. 
    
11. backup database link to disk=@Num with format
    

复制代码

备份的时候几下日志，恢复的时候就可以直接记下了