Backup Maintenance Plan -> MSDE

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
I have the same Problem. Do you have an answer?
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||I don't know why the gui is doing that (do you have the latest service packs
installed?) but it should be easy enough to fix. Since the removal of old
backups is not stored in metadata tables you can edit this pretty easy. It
is simply an option to the xp_sqlmaint call.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
9EEB1492-1A6C-4F16-B752-D86A325127CA -VrfyBackup -BkUpMedia DISK -BkUpDB
"C:\Data\Backups" -DelBkUps 4WEEKS -BkExt "BAK"'
The above is what the job step looks like for a Full backup plan that I just
created with a delete of 4 weeks. check out BooksOnLine under "sqlmaint
utility" for details on what each of the options are. So just edit the job
to be the way you want it with regards to the delete part.
Andrew J. Kelly SQL MVP
"Gaston Oxman" <oxmangas@.hotmail.com> wrote in message
news:%23SektOLEFHA.1564@.TK2MSFTNGP09.phx.gbl...
> I have the same Problem. Do you have an answer?
> Thanks
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

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
>
>