--备份
backup database sys to disk='c:\目录\a.bak' with init
--还原
use master
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat'
backup database sys to disk='c:\目录\a.bak' with init
--还原
use master
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat'
backup database 数据库名 to disk='c:\数据备份.bak'你可以在程序中直接执行上述语句实现:数据库给导出来,存成一个文件
NOUNLOAD , NAME = N'j备份', NOSKIP , STATS = 10, NOFORMAT
cb_1.enabled=false
sqlstring = "BACKUP DATABASE "+ dw_1.gettext()+ " TO disk = '"+sle_1.text+"' WITH FORMAT,NAME = '"+dw_1.gettext()+"的全备份'"
SQLCA.Autocommit=true;
execute immediate :sqlstring using SQLCA;
commit;
SQLCA.Autocommit=false
cb_1.enabled=true拿人家的