你的意思就是只要一个备份文件就行了,再有新的就复盖这个文件的意思吧,保持一个最新文件?
backup database gutl to disk='c:\gutl.full' with init 这样就行了
如果不在本机上备,在异地就
BACKUP DATABASE test TO DISK =N'\\test\dbbak\test.full'
-- Create a full database backup first.
BACKUP DATABASE MyNwind
TO MyNwind_1
WITH INIT
GO
-- Time elapses.
-- Create a differential database backup, appending the backup
-- to the backup device containing the database backup.
BACKUP DATABASE MyNwind
TO MyNwind_1
WITH DIFFERENTIAL
GO
首先要有full备份