怎么样编写程序自动还原数据库，不是手工还原：）

Question

最好要做成发布软件的形式：）

Answer 1

备份
BACKUP DATABASE Northwind 
   TO DISK = 'c:\Northwind.bak'
恢复
RESTORE FILELISTONLY 
   FROM DISK = 'c:\Northwind.bak'

Answer 2

adocommand1.CommandText:='restore database yourdatabase fromdisk=''d:\Program   Files\Microsoft SQL Server\MSSQL\BACKUP\yd.back'' with replace';
  try
     adocommand1.Execute;
     showmessage('恢复成功！');
   except
     showmessage('恢复失败！');
   end;

Answer 3

adocommand1.CommandText:='restore database yourdatabase from disk=''d:\Program   Files\Microsoft SQL Server\MSSQL\BACKUP\yd.back'' with replace';
  try
     adocommand1.Execute;
     showmessage('恢复成功！');
   except
     showmessage('恢复失败！');
   end;