Question

关于 SQL server 2005 备份计划问题

Answer 1

--示例
数据库为
abc
备份在F:\

--把下面的代码做成一个作业计划就行了。
set
nocount
on

declare
@n
nvarchar(255)
set
@n
='F:\'

declare
@date
nvarchar(20)
set
@date
=
convert(nvarchar,
getdate(),120)

select
@date
=replace(
replace(replace(@date,'-',''),':',''),'
','')
+'.bk'

declare
@n1
nvarchar(255)

set
@n1
=
@n
+
'abc'+@date

BACKUP
DATABASE
[abc]
TO
DISK
=
@n1
WITH
NOINIT
,
NOUNLOAD
,
NAME
=
N'备份',
NOSKIP
,
STATS
=
10,
NOFORMAT