Question

delphi 各位高手,如何在delphi中恢复备份了的sqlserver数据库

我用的是delphi6和sqlserver2000,数据连接用的ado,主要想在delphi中实现数据库的备份和恢复,目前备份利用的是ADOCommand组件执行"backup database labor to disk=:disk with init"语句将数据库备份为一个文件,可是恢复不知如何恢复,定当给分,决不食言

Answer 1

//备份if SaveDialog1.Execute then with ADOCommand do begin CommandText:='backup database DBName to disk=''' + SaveDialog1.FileName + ''' with init'; Execute; end;//恢复if OpenDialog1.Execute then with ADOCommand do begin CommandText:='Restore database DBName from disk=''' + OpenDialog1.FileName + ''''; Execute; end; 查看原帖>>