sql server new users: Maintenance Plans -- sql server new users

Maintenance Plans

Tracy Montgomery
11/16/2006 7:19:17 AM

sql server new users:

I have a maintenance plan set-up to backup all user databases on SQL 2000
Server. I was wondering if there is any way to modify the .bak file format.
Currently the bak files are (saved to disk and written to tape) with the
following format (user_db_2006111160200.bak.) Is there any way to exclude
the time stamp when saving the .bak files.

Thanks,

Tracy

Re: Maintenance Plans

Anthony Thomas
11/19/2006 3:09:43 PM

Maintenance plans create jobs that utilize the xp_sqlmaint extended stored
procedure, which is just a callout to the sqlmaint.exe utility.

From Books Online, the backup name format is hard-coded, and cannot be
altered.

Sincerely,

Anthony Thomas

--

[quoted text, click to view]