asp.net在线备份SQL Server数据库

最新推荐文章于 2014-05-06 09:15:00 发布

SmartJavaer

最新推荐文章于 2014-05-06 09:15:00 发布

阅读量1.3k

点赞数

分类专栏： Asp.net C# DataBase 文章标签： sql server asp.net 数据库 database

61 篇文章 0 订阅

订阅专栏

55 篇文章 0 订阅

订阅专栏

9 篇文章 0 订阅

订阅专栏

asp.net在线备份SQL Server数据库

Dim oBackup As SQLDMO.Backup = new SQLDMO.BackupClass() Dim oSQLServer As SQLDMO.SQLServer = new SQLDMO.SQLServerClass() oSQLServer.LoginSecure = false oSQLServer.Connect("localhost", "sa", "密码") oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database oBackup.Database = "数据库" oBackup.Files = "D:/Jnszf.bak" oBackup.BackupSetName = "数据库" oBackup.BackupSetDescription = "数据库备份" oBackup.Initialize = true oBackup.SQLBackup(oSQLServer) oSQLServer.DisConnect() Dim fi As System.IO.FileInfo = new System.IO.FileInfo("D:/Jnszf.bak")