Prev: Difference between SQL 2008 Server Express and SQL 2008 R2 Express
Next: Error on log file growth.
From: Alexmela78 on 26 Apr 2010 10:11
Hi,
I have configured two maintenance plan to make backup of all databases.
one nightly to backup from monday to saturday and
one weekly to backup on sunday.

the filename of all backup has generated automatically from the system and
it is:
<db-name>_backup_<date>_<random numbers>.bak.

is it possible add in file name a word? example. to backup from mon to sat,
filename_daily.bak and to backup on sunday filename_weekly.bak

Thanks

Alexmela78
From: TheSQLGuru on 26 Apr 2010 12:05
I recommend you stop using maintenance plans and control your maintenance
yourself. See ola.hallengren.com for some marvelous scripts for doing just
that.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Alexmela78" <Alexmela78(a)discussions.microsoft.com> wrote in message
news:42EEC74B-7A2D-48CE-BCC6-0858C1428C0F(a)microsoft.com...
> Hi,
> I have configured two maintenance plan to make backup of all databases.
> one nightly to backup from monday to saturday and
> one weekly to backup on sunday.
>
> the filename of all backup has generated automatically from the system and
> it is:
> <db-name>_backup_<date>_<random numbers>.bak.
>
> is it possible add in file name a word? example. to backup from mon to
> sat,
> filename_daily.bak and to backup on sunday filename_weekly.bak
>
> Thanks
>
> Alexmela78


From: Manpreet Singh on 27 Apr 2010 07:50
Hi,

You can not do this through Back Up Database Task. but you can add a script
task after it and rename databases ones backup task get over. This is only
workaround to rename backups using maintenance plan. But my advice is to
create a job using TSQL scripts. This will give you much more control over
your backups.


Manpreet Singh
http://crazysql.wordpress.com/
MCITP (DBA, Developer) SQL Server 2005
MCTS (MOSS 2007), ITILv3F


"Alexmela78" wrote:

> Hi,
> I have configured two maintenance plan to make backup of all databases.
> one nightly to backup from monday to saturday and
> one weekly to backup on sunday.
>
> the filename of all backup has generated automatically from the system and
> it is:
> <db-name>_backup_<date>_<random numbers>.bak.
>
> is it possible add in file name a word? example. to backup from mon to sat,
> filename_daily.bak and to backup on sunday filename_weekly.bak
>
> Thanks
>
> Alexmela78
 | 
Pages: 1
Prev: Difference between SQL 2008 Server Express and SQL 2008 R2 Express
Next: Error on log file growth.