Home Forums SQL Server 2008 SQL Server 2008 Administration Maintance plan -- full backup error RE: Maintance plan -- full backup error
sita.yeleswarapu
Mr or Mrs. 500
Points: 574
More actions
December 25, 2013 at 2:52 am
#1675875
Declare @path Varchar(200)
set @path='xxxx'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'
BACKUP DATABASE [xxxx]
TO DISK = @path