Backup maintenance plan - MSDE 2000

Hi
I have a problem creating a backup maintenance plan on MDSE 2000 using the
wizard. I want the backup to be written to disk and not into the default
backup directory. First I set the schedule to Sundays at 02:00 and in the
next prompt I set it to write the backup to D:\SQLBUP. So far everything
looks ok but when I try to set that old files should be removed, I can only
set the number but not of what (hours, days, weeks etc). That dropdown menu
is completely blank. So I skip it and set the file extension to BAK. I finish
the rest of the wizard with the default values.
When the maintenance plan is finished I go back and look at its properties.
Strangely enough the path I set for the backup is now blank and so is the
schedule!
Even if I try to set it again in the properties and then click ok and open
it again it is once more lost!
Can anybody tell me why?
Is it because it is MSDE or...?
Regards
Wayne
hi Wayne,
Wayne Gore wrote:
> Hi
> I have a problem creating a backup maintenance plan on MDSE 2000
> using the wizard. I want the backup to be written to disk and not
> into the default backup directory. First I set the schedule to
> Sundays at 02:00 and in the next prompt I set it to write the backup
> to D:\SQLBUP. So far everything looks ok but when I try to set that
> old files should be removed, I can only set the number but not of
> what (hours, days, weeks etc). That dropdown menu is completely
> blank. So I skip it and set the file extension to BAK. I finish the
> rest of the wizard with the default values.
> When the maintenance plan is finished I go back and look at its
> properties. Strangely enough the path I set for the backup is now
> blank and so is the schedule!
> Even if I try to set it again in the properties and then click ok and
> open it again it is once more lost!
> Can anybody tell me why?
> Is it because it is MSDE or...?
> Regards
> Wayne
no, it's becouse of the maintenance plan wizard, that mess all thins a
little..
my advice, keep away from maintenance plan ad write your own Ttransact-SQL
job to perform all required steps..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I am having the exact problem; Blank menus..
Initially it was the NT\admin auth error so I
edited the job itself and added the -S -U -P and got passed that error.
Then I notice the -UseDefDir, and when you look at the Grid tab you see the
error
"Could not find the directory for database xxxxx . backups may not succeed."
I tried using the -BkUpDB and the path, then the Grid changed to the
sqlmaint /?
giving me all of the options and no other errors.
Is there any thing out there ??
I'm using msde 2000 sp3
"Andrea Montanari" wrote:

> hi Wayne,
> Wayne Gore wrote:
> no, it's becouse of the maintenance plan wizard, that mess all thins a
> little..
> my advice, keep away from maintenance plan ad write your own Ttransact-SQL
> job to perform all required steps..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>