Database Maint issue

I've got an issue when creating a database maintenance plan. When I get to
the
Specify Backup Disk Directory (in the DB Maintenance Plan Wizard), the
drop-down box for specifying the remove files older than is blank, and the
default timeframe is 0, and the Backup file extension is blank. On other SQL
servers, by default these locations show the drop-down as Week(s), the
timeframe as 4, and the extention as BAK.
If I continue setting up the maintenance plan, when I get to the Specify
Transaction Log Backup Disk Directory, I'll run into the same problem as the
Database (blank and 0 for the same fields).
In any event it will allow me to setup the plans, however I'd like to be
able to set the remove feature and I can't...
Any ideas?
hi,
Darth Blubber wrote:
> I've got an issue when creating a database maintenance plan. When I
> get to the
> Specify Backup Disk Directory (in the DB Maintenance Plan Wizard), the
> drop-down box for specifying the remove files older than is blank,
> and the default timeframe is 0, and the Backup file extension is
> blank. On other SQL servers, by default these locations show the
> drop-down as Week(s), the timeframe as 4, and the extention as BAK.
> If I continue setting up the maintenance plan, when I get to the
> Specify Transaction Log Backup Disk Directory, I'll run into the same
> problem as the Database (blank and 0 for the same fields).
> In any event it will allow me to setup the plans, however I'd like to
> be able to set the remove feature and I can't...
> Any ideas?
this is a long nightmare with Maintenance Plan withard (which actually is
very buggy)... please have a look at
http://groups.google.it/groups?as_q=...0&as_maxy=2005
for a short idea...
I strongly recommend you to write your own SQL Server jobs in
Transact-SQL... this can be a little bit longer than in the wizard,
requiring you to improve your skills, but it will pay in the long terms...
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply