【转载】如何备份数据库和删除备份

--完全备份数据库

declare @strpath nvarchar(200)

declare @date datetime

select @date=getdate()

select @strpath='F:\backup\'+cast(datepart(yyyy,@date) as varchar(4))+'-'+cast(datepart(mm,@date) as varchar(2))+'-'+cast(datepart(dd,@date) as varchar(2))+'.bak'

backup database [数据库名] to disk=@strpath with init

go

 

--只保留最近三天内的备份

declare @olddate datetime

select @olddate=getdate()-3

execute master.dbo.xp_delete_file 0,N'F:\backup',N'bak',@olddate,1

go