access可以直接备份文件,sql可以用下面的存储过程完成
Statement
"CREATE PROCEDURE sdDb_Backup
@DatabaseName varchar(40),
@FileName varchar(80),
@UserCode varchar(18)
AS
backup database @DatabaseName To DISK=@Filename WITH INIT
if @@Error=0
begin
update sdBackup Set BackupDate=getdate(),
BackupUser=@UserCode
where BackupFile=@FileName
if @@RowCount<1
Insert into sdBackup (BackupDate,BackupFile,BackupUser)
values(Getdate(),@FileName,@UserCode)
end