Re: Maintenance Plan Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 15:21:57 -0400

You have to specify a UNC path and don't use a mapped drive. 

-- 
Andrew J. Kelly  SQL MVP
"Dan Jacobs" <daniel.jacobs@thomson.net> wrote in message
news:0be701c46e84$6c8a2df0$a301280a@phx.gbl...
> Hopefully this has a simple answer. Running SQL2000SP3 on
> Win2K Server. Would like to create a maintenance plan that
> can be directed to a network share that has been mapped
> locally. Performing a backup to this share is no problem,
> but share is not available when setting up the directory
> setting in the maintenance plan. Any advise would be
> appreciated. Thanks
>
> DJ

Relevant Pages

  • Re: Error 22029 on Maintenance Plan
    ... > Thanks, Andrew, I'll give that a try. ... >> Andrew J. Kelly SQL MVP ... Maintenance plan 1 is for user databases ... >>> databases and does not do log backups. ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance Plan Fails
    ... Andrew J. Kelly SQL MVP ... a maintenance plan against the restored databases. ... When I execute the plan it works fine on the newly created test database. ...
    (microsoft.public.sqlserver.tools)
  • Re: Customizing maintenance plan reporting in SQL2005
    ... Thanks, Andrew. ... Is there a way to customize the maintenance plan e-mail reporting? ...
    (microsoft.public.sqlserver.tools)
  • Re: Error 22029 on Maintenance Plan
    ... Thanks, Andrew, I'll give that a try. ... >> A Backup Exec SQL agent is used to backup the live databases, ... >> hour later than the maintenance plan. ...
    (microsoft.public.sqlserver.server)