紧急求助,紧急求助,紧急求助,紧急求助,紧急求助,紧急求助,紧急求助,紧急求助,
我写了个存储过程,想执行增量备份。
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER procedure backupdata
as
exec sp_addumpdevice 'disk','fundata1','d:\fundata1.dat'
exec sp_addumpdevice 'disk','fundatalog','d:\fundatalog.dat'
backup database funwygl to fundata1 with differential
backup log funwygl to fundatalog with differential
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
//错误提示:
One or more of the options (differential) are not supported for this statement. Review the documentation for supported options.
2,我还想增加几句,就是把这个本分任务加到JOB里面去,然后可以得到一个返回值,
我是前台调用这个存储过程,得到返回值,判断是否成功。