[Gex55]

Надо менять скрипт бэкапа
Например вот так

Код:

DECLARE @dateString CHAR(12), @daySTR CHAR(2), @monthSTR CHAR(2), @hourSTR CHAR(2), @minSTR CHAR(2)
--month variable
IF (SELECT LEN(CAST(MONTH(GETDATE()) AS CHAR(2))))=2
   SET @monthSTR=CAST(MONTH(GETDATE()) AS CHAR(2))
ELSE
   SET @monthSTR= '0' + CAST(MONTH(GETDATE()) AS CHAR(2))
--day variable
IF (SELECT LEN(CAST(DAY(GETDATE()) AS CHAR(2))))=2
   SET @daySTR=CAST(DAY(GETDATE()) AS CHAR(2))
ELSE
   SET @daySTR='0' + CAST(DAY(GETDATE()) AS CHAR(2))
--hour variable
IF (SELECT LEN(DATEPART(hh, GETDATE())))=2
   SET @hourSTR=CAST(DATEPART(hh, GETDATE()) AS CHAR(2))
ELSE
   SET @hourSTR= '0' + CAST(DATEPART(hh, GETDATE()) AS CHAR(2))
--minute variable
IF (SELECT LEN(DATEPART(mi, GETDATE())))=2
   SET @minSTR=CAST(DATEPART(mi, GETDATE()) AS CHAR(2))
ELSE
   SET @minSTR= '0' + CAST(DATEPART(mi, GETDATE()) AS CHAR(2))
--name variable based on time stamp
SET @dateString=CAST(YEAR(GETDATE()) AS CHAR(4)) + @monthSTR + @daySTR + @hourSTR + @minSTR
--=================================================================
DECLARE @SQL VARCHAR(1000), @DBNAME VARCHAR(200), @CheckResult VARCHAR(200), @PDASERVER as varchar(20)
   SELECT @DBNAME = NAME FROM sys.databases WHERE name like '%Название базы%'
   SELECT @SQL = 'BACKUP DATABASE '+@DBNAME+' TO DISK = ''E:\Backup\'+@DBNAME+'_db_' + @dateString +'.bak'' WITH INIT'
   EXEC (@SQL)

Ессно вместо названия базы пишете свою базу и путь напишите свой, а с датой думаю поиграете как надо будет