TA的每日心情 | 开心 2011-3-14 19:11 |
---|
签到天数: 38 天 [LV.5]常住居民I
|
发表于 2010-10-20 09:06:50
|
显示全部楼层
贴出SQL自动备份的脚本,供SQL不太精通者参考
Declare @Name varchar(40)
Declare @FileName varchar(300)
Declare @DataName varchar(40)
Declare @BakDir varchar(40)
Declare @Tmp varchar(2)
Select @BakDir="F:\ERP_BAK\"
DECLARE @name varchar(40)
DECLARE DBName CURSOR FOR
SELECT MB003 FROM (SELECT RTRIM(MB003) AS MB003 FROM DSCSYS.dbo.DSCMB WHERE (NOT (RTRIM(MB003) LIKE
'TEST%')) UNION SELECT 'DSCSYS' AS MB003) A
OPEN DBName
FETCH NEXT FROM DBName
INTO @DataName
WHILE @@FETCH_STATUS = 0
BEGIN
Select @Name=@DataName +" backup"
Select @Tmp=Convert(varchar(2),DATEPART(dw,GetDate()))
if Len(@Tmp)=1 Select @Tmp="0"+@Tmp
Select @FileName=@BakDir+@DataName+"-"+@Tmp+".BAK"
BACKUP DATABASE @DataName TO DISK = @FileName WITH INIT , NOUNLOAD , NAME = @Name, NOSKIP , STATS = 10,
NOFORMAT
FETCH NEXT FROM DBName
INTO @DataName
END
CLOSE DBName
DEALLOCATE DBName
GO |
|