使用SQLDMO备份和恢复数据库代码,VB.Net代码库,德仔网

代码语言

代码分类

【VB.Net】使用SQLDMO备份和恢复数据库

作者:Athrun / 发布于2012/8/1/ 1292

SQLDMO备份和恢复数据库,引用Microsoft SQLDMO Object Library先

<div>Private objSQLServer As New SQLDMO.SQLServer</div>
<div>Private Sub cmdBackup_Click() 
Dim objBackup As New SQLDMO.backup</div>
<div>objBackup.Database = "pubs" 
objBackup.MediaName = "C:\Mssql7\Backup\pubs.bak" 
'If you backup to tape, you can use 
'objBackup.MediaName = "<a href="file://\\.\TAPE0">\\.\TAPE0</a>" 
objBackup.MediaDescription = "Back of pubs" 
objBackup.SQLBackup (objSQLServer) 
End Sub</div>
<div>Private Sub cmdRestore_Click() 
Dim objRestore As New SQLDMO.Restore 
objRestore.Database = "pubs" 
objRestore.MediaName = "C:\Mssql7\Backup\pubs.bak" 
objRestore.ReplaceDatabase = True 
objRestore.SQLRestore (objSQLServer) 
End Sub</div>
<div>Private Sub Form_Load() 
objSQLServer.Connect "Localhost", "sa", "" 
End Sub</div>

试试其它关键字

　备份和恢复数据库　

同语言下

可能有用的

Athrun贡献的其它代码(6)