DB maint. plan - UNC problem

Hi,
I'm attempting to use a UNC path within a Database Maintenance Plan, and
receiving a 'cannot create' O/S error. The maintenance plan accepts the path
to the server/share, but the subsequent SQL job fails with the above error.
I believe maintenance plans can't use UNC paths. Is this true? Is there a
way around this problem?
My alternative is to create a database device, and backup the databases in
that manner, but I want the retention/deletion features of the maintenance
plan.
Cheers,
James G.It can use them but the account that SQL Server runs under must have the
proper permissions to use this share. If SQL Server is running under the
local admin account it can not see the share on a remote server.
Andrew J. Kelly SQL MVP
"Jimbo" <james.goodwill@.mail.com> wrote in message
news:L8hKf.13177$gB4.4335@.newsfe4-gui.ntli.net...
> Hi,
> I'm attempting to use a UNC path within a Database Maintenance Plan, and
> receiving a 'cannot create' O/S error. The maintenance plan accepts the
> path
> to the server/share, but the subsequent SQL job fails with the above
> error.
> I believe maintenance plans can't use UNC paths. Is this true? Is there a
> way around this problem?
> My alternative is to create a database device, and backup the databases in
> that manner, but I want the retention/deletion features of the maintenance
> plan.
> Cheers,
> James G.
>|||Sorry meant to add this: http://support.microsoft.com/?kbid=555128
Andrew J. Kelly SQL MVP
"Jimbo" <james.goodwill@.mail.com> wrote in message
news:L8hKf.13177$gB4.4335@.newsfe4-gui.ntli.net...
> Hi,
> I'm attempting to use a UNC path within a Database Maintenance Plan, and
> receiving a 'cannot create' O/S error. The maintenance plan accepts the
> path
> to the server/share, but the subsequent SQL job fails with the above
> error.
> I believe maintenance plans can't use UNC paths. Is this true? Is there a
> way around this problem?
> My alternative is to create a database device, and backup the databases in
> that manner, but I want the retention/deletion features of the maintenance
> plan.
> Cheers,
> James G.
>|||Hi
Maintenance Plans should be able to take a UNC path, make sure that the SQL
Agent Service Account has sufficient permissions to access this location.
John
"Jimbo" wrote:

> Hi,
> I'm attempting to use a UNC path within a Database Maintenance Plan, and
> receiving a 'cannot create' O/S error. The maintenance plan accepts the pa
th
> to the server/share, but the subsequent SQL job fails with the above error
.
> I believe maintenance plans can't use UNC paths. Is this true? Is there a
> way around this problem?
> My alternative is to create a database device, and backup the databases in
> that manner, but I want the retention/deletion features of the maintenance
> plan.
> Cheers,
> James G.
>
>