直接执行上面的语句啊:例如,用ADO方法:
connection.execute "Restore DataBase QHFZDB
From Disk='\\TH\d\uuu'
WITH Move 'QHFZDB' To '\\TH\d\uuu.mdf',
MOVE 'QHFZDB_Log' TO '\\TH\d\uuu.ldf'"
connection.execute "Restore DataBase QHFZDB
From Disk='\\TH\d\uuu'
WITH Move 'QHFZDB' To '\\TH\d\uuu.mdf',
MOVE 'QHFZDB_Log' TO '\\TH\d\uuu.ldf'"
connection.execute "Restore DataBase QHFZDB
From Disk='d:\uuu'
WITH Move 'QHFZDB' To 'd:\uuu.mdf',
MOVE 'QHFZDB_Log' TO 'd:\uuu.ldf'"
connection.execute "Restore DataBase QHFZDB
From Disk='\\TH\d\uuu'
WITH Move 'QHFZDB' To '\\TH\d\uuu.mdf',
MOVE 'QHFZDB_Log' TO '\\TH\d\uuu.ldf'"注意,上述是传递到SQL SERVER上去执行的,所以所有目录都是相对服务器而言如果你的数据库及路径本身就是在服务器上,就直接写:
connection.execute "Restore DataBase QHFZDB
From Disk='d:\uuu'
WITH Move 'QHFZDB' To 'd:\uuu.mdf',
MOVE 'QHFZDB_Log' TO 'd:\uuu.ldf'"
如果在sql服务器上的话,直接执行上边的语句就可以了