winfrom 中用数据备份和还原.(ms-sql2005) winfrom 中用数据备份和还原.(ms-sql2005) 具体代码怎么写? 指导一下谢谢各位了!!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System; 2 3namespace DbService 4{ 5 /// <summary> 6 /// DbOper类,主要应用SQLDMO实现对Microsoft SQL Server数据库的备份和恢复 7 /// </summary> 8 public sealed class DbOper 9 {10 /// <summary>11 /// DbOper类的构造函数12 /// </summary>13 private DbOper()14 {15 }1617 /// <summary>18 /// 数据库备份19 /// </summary>20 public static void DbBackup()21 {22 SQLDMO.Backup oBackup = new SQLDMO.BackupClass();23 SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();24 try25 {26 oSQLServer.LoginSecure = false;27 oSQLServer.Connect("localhost", "sa", "1234");28 oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;29 oBackup.Database = "Northwind";30 oBackup.Files = @"d:\Northwind.bak";31 oBackup.BackupSetName = "Northwind";32 oBackup.BackupSetDescription = "数据库备份";33 oBackup.Initialize = true;34 oBackup.SQLBackup(oSQLServer);35 }36 catch37 {38 throw;39 }40 finally41 {42 oSQLServer.DisConnect();43 }44 }4546 /// <summary>47 /// 数据库恢复48 /// </summary>49 public static void DbRestore()50 {51 SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();52 SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();53 try54 {55 oSQLServer.LoginSecure = false;56 oSQLServer.Connect("localhost", "sa", "1234");57 oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;58 oRestore.Database = "Northwind";59 oRestore.Files = @"d:\Northwind.bak";60 oRestore.FileNumber = 1;61 oRestore.ReplaceDatabase = true;62 oRestore.SQLRestore(oSQLServer);63 }64 catch65 {66 throw;67 }68 finally69 {70 oSQLServer.DisConnect();71 }72 }73 }74}http://www.cnblogs.com/efish/archive/2006/10/23/537336.html json里面有数组怎么读取啊 DataSet插入缓存后,哪些方法不应该用?否则数据会丢失 50分求个白痴问题_新手问题! 面试题,求高手解决? 判断一个对象是否已经被实例化的问题 想用winform+sql server2000开发一个数据库软件,请大家给点意见和经验. 数据库流问题 麻烦给加上注释 谢谢大牛 我重写了DataGrid控件,在最后一行加了一个合计行,但如果控件出现垂直滚动条时,有时还没完全显示出合计行,滚动条就滚不动了,该怎么办? 严格定时执行方法的思路 c#子窗体与子窗体之间的内容的链接 如何把textbox里的路径传递给外部调用的EXE程序
using System;
2
3namespace DbService
4{
5 /// <summary>
6 /// DbOper类,主要应用SQLDMO实现对Microsoft SQL Server数据库的备份和恢复
7 /// </summary>
8 public sealed class DbOper
9 {
10 /// <summary>
11 /// DbOper类的构造函数
12 /// </summary>
13 private DbOper()
14 {
15 }
16
17 /// <summary>
18 /// 数据库备份
19 /// </summary>
20 public static void DbBackup()
21 {
22 SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
23 SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
24 try
25 {
26 oSQLServer.LoginSecure = false;
27 oSQLServer.Connect("localhost", "sa", "1234");
28 oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
29 oBackup.Database = "Northwind";
30 oBackup.Files = @"d:\Northwind.bak";
31 oBackup.BackupSetName = "Northwind";
32 oBackup.BackupSetDescription = "数据库备份";
33 oBackup.Initialize = true;
34 oBackup.SQLBackup(oSQLServer);
35 }
36 catch
37 {
38 throw;
39 }
40 finally
41 {
42 oSQLServer.DisConnect();
43 }
44 }
45
46 /// <summary>
47 /// 数据库恢复
48 /// </summary>
49 public static void DbRestore()
50 {
51 SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
52 SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
53 try
54 {
55 oSQLServer.LoginSecure = false;
56 oSQLServer.Connect("localhost", "sa", "1234");
57 oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
58 oRestore.Database = "Northwind";
59 oRestore.Files = @"d:\Northwind.bak";
60 oRestore.FileNumber = 1;
61 oRestore.ReplaceDatabase = true;
62 oRestore.SQLRestore(oSQLServer);
63 }
64 catch
65 {
66 throw;
67 }
68 finally
69 {
70 oSQLServer.DisConnect();
71 }
72 }
73 }
74}http://www.cnblogs.com/efish/archive/2006/10/23/537336.html