Thrown into the pit xp_sqlmaint

I am managing maintenence plans on SQL Server.   The plan is failing with
permissions and nothing has changed in the script below.  Could a part of
this require permissions?  You should know that the backup folder is on a
server other than the production server.  That server is a 2005 version of
the SQL 2000 production.

EXECUTE master.dbo.xp_sqlmaint N'-PlanID
7FD436BA-8B18-4E96-937D-C2FB7F87F5F2 -To "GENL Alerts" -WriteHistory
-VrfyBackup -BkUpMedia DISK -BkUpDB "\\SVR\SVRBKPFOLDER" -DelBkUps 7HOURS
-BkExt "BAK"'
--
Regards,
Jamie

thejamie  wrote:
> I am managing maintenence plans on SQL Server.   The plan is failing with
> permissions and nothing has changed in the script below.  Could a part of
> this require permissions?  You should know that the backup folder is on a
> server other than the production server.  That server is a 2005 version of
> the SQL 2000 production.
>
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 7FD436BA-8B18-4E96-937D-C2FB7F87F5F2 -To "GENL Alerts" -WriteHistory
> -VrfyBackup -BkUpMedia DISK -BkUpDB "\\SVR\SVRBKPFOLDER" -DelBkUps 7HOURS
> -BkExt "BAK"'

Check the service account for SQL Server and SQL Agent, see what domain
login they are running as.  That domain login needs to have read/write
permissions on the share that you are sending backups to.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Make sure the SQL Server service account has FULL CONTROL permissions on the
designated share and the underlying NTFS folders.  Also, all subfolders must
exist.

See
http://support.microsoft.com/kb/555128/en-us
For full details

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:AAD8AD71-4EDD-4661-A3AB- 821430715812@microso
ft.com...
>I am managing maintenence plans on SQL Server.   The plan is failing with
> permissions and nothing has changed in the script below.  Could a part of
> this require permissions?  You should know that the backup folder is on a
> server other than the production server.  That server is a 2005 version of
> the SQL 2000 production.
>
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 7FD436BA-8B18-4E96-937D-C2FB7F87F5F2 -To "GENL Alerts" -WriteHistory
> -VrfyBackup -BkUpMedia DISK -BkUpDB "\\SVR\SVRBKPFOLDER" -DelBkUps 7HOURS
> -BkExt "BAK"'
> --
> Regards,
> Jamie