1、ACCESS?直接拷贝文件;
2、SQL Server?
--Full database backup
USE master
EXEC sp_addumpdevice 'DISK', 'MyDatabase_1', 'g:\temp\bakup_db.dat'
BACKUP DATABASE MyDatabase TO MyDatabase_1 --Full database restore
RESTORE DATABASE MyDatabase
FROM MyDatabase_1
详细的内容可查看SQL Server books online相关的内容
2、SQL Server?
--Full database backup
USE master
EXEC sp_addumpdevice 'DISK', 'MyDatabase_1', 'g:\temp\bakup_db.dat'
BACKUP DATABASE MyDatabase TO MyDatabase_1 --Full database restore
RESTORE DATABASE MyDatabase
FROM MyDatabase_1
详细的内容可查看SQL Server books online相关的内容
backup database databasename
to disk='c:\bak\example.dat'
编程时,可用一个query执行以上语句,而且数据库名和备份文件命都可以作为变量传入