Hello,
I'm using the page http://support.microsoft.com/kb/930615 tutorial to
schedule a daily backup on my database.

Backup works fine, and I'm able to restore from the backup file. However
since it is a daily backup, I prefer the backup file name as 'xxx-<date>'
instead of 'xxx'.

How can I archive that?

The command of Job is as following:
BACKUP DATABASE [xxx] TO DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Backup\xxx' WITH NOFORMAT,
INIT, NAME = N'xxx-Full Database Backup test', SKIP, NOREWIND, NOUNLOAD,
STATS = 10
GO

Thanks in advance.

DECLARE @cmd nvarchar (255)

SET @cmd ='
BACKUP DATABASE [xxx] TO DISK = ''C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Backup\xxx-' + convert(varchar(16), getdate(),112)+
'.bak''
WITH NOFORMAT, INIT, NAME = N''xxx-Full Database Backup test'', SKIP,
NOREWIND, NOUNLOAD, STATS = 10
'
Print @cmd
EXECUTE sp_executesql @cmd


"wc" <wc (AT) discussions (DOT) microsoft.com> wrote