请问是如何实现的?可否具体些.我想,就是做一个数据库的还原吧,于是我这样做:原数据库名:jxcmain自己写了以下语句:
'备份SQL数据库
Public Function BackupSQLDB(dbName As String, backupFullFileName As String) As Boolean
Dim cn As New ADODB.Connection
On Error GoTo err
Set cn = GetConnection()
cn.Execute "BACKUP DATABASE " & dbName & " TO DISK='" & backupFullFileName & "'"
BackupSQLDB = True
Exit Function
err:
BackupSQLDB = False
End Function'恢复SQL数据库
Public Function RestoreSQLDB(backupFullFileName As String, restoreDBName As String) As Boolean
Dim cn As New ADODB.Connection
On Error GoTo err
Set cn = GetConnection()
cn.BeginTrans
cn.Execute "USE MASTER"
cn.Execute "RESTORE DATABASE " & restoreDBName & " FROM DISK='" & backupFullFileName & "' WITH REPLACE"
cn.CommitTrans
RestoreSQLDB = True
Exit Function
err:
cn.RollbackTrans
RestoreSQLDB = False
End Function
用以上的两个函数备份还原没问题.
问题是:我想把数据库jxcmain还原成jxc001,就不行了,如何修改?
'备份SQL数据库
Public Function BackupSQLDB(dbName As String, backupFullFileName As String) As Boolean
Dim cn As New ADODB.Connection
On Error GoTo err
Set cn = GetConnection()
cn.Execute "BACKUP DATABASE " & dbName & " TO DISK='" & backupFullFileName & "'"
BackupSQLDB = True
Exit Function
err:
BackupSQLDB = False
End Function'恢复SQL数据库
Public Function RestoreSQLDB(backupFullFileName As String, restoreDBName As String) As Boolean
Dim cn As New ADODB.Connection
On Error GoTo err
Set cn = GetConnection()
cn.BeginTrans
cn.Execute "USE MASTER"
cn.Execute "RESTORE DATABASE " & restoreDBName & " FROM DISK='" & backupFullFileName & "' WITH REPLACE"
cn.CommitTrans
RestoreSQLDB = True
Exit Function
err:
cn.RollbackTrans
RestoreSQLDB = False
End Function
用以上的两个函数备份还原没问题.
问题是:我想把数据库jxcmain还原成jxc001,就不行了,如何修改?
解决方案 »
- 。(provider:命名管道提供程序,error:0-管道的另一端上无任何进程),哥要崩溃了
- 两张表连接的问题(急!!)
- 绊脚小问题,请各位高手指点
- SQL Sever 安装过程中出现报错
- 每添加一行数据,cNumber自动添加一个按顺序依次向下的记录。用default如何实现?
- 心煩死了,誤差問題,各位大蝦來幫幫忙呀
- -------Insert 语句中关于字段个数与插入值个数不相同的情况,如何解决?谢谢!
- 请问:在多对多的关系中,关系是否一定映射成表吗?
- 关于SQL Server 数据库 nvarchar 和 ntext 字段的问题。
- 存储过程中带有增删改语句时,如何用ADO取得返回的纪录集?
- SQL如何在存储过程里写一个代码显示两个表的字段?
- 请问2005里面多出一个构架,请问它是干嘛用的
如何来弄?
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO
下例显示使用 BACKUP 和 RESTORE 语句创建 Northwind 数据库的复本。MOVE 语句使数据和日志文件还原到指定的位置。RESTORE FILELISTONLY 语句用于确定待还原数据库内的文件数及名称。该数据库的新复本称为 TestDB。有关更多信息,请参见 RESTORE FILELISTONLY。 BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO