| Author |
Thrown into the pit xp_sqlmaint
|
|
| thejamie 2006-10-31, 7:13 pm |
| 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
| |
| Tracy McKibben 2006-10-31, 7:13 pm |
| 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
| |
| Geoff N. Hiten 2006-10-31, 7:13 pm |
| 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
|
|
|
|