Maintenance Plan

Hi,
I am trying to set up a backup maintenance plans for one of my database
using SQL Server 2005, I have made sure that the account that I am using to
run the job has the necessary permissions on the remote server to create
folders as I am trying to put the backup onto a mapped drive.
When you view the scrip it looks like the following
EXECUTE master.dbo.xp_create_subdir N'g:\\ADMIN'
GO
BACKUP DATABASE [ADMIN] TO DISK = N'g:\\ADMIN\ADMIN_backup_200710151017.bak' WITH NOFORMAT, NOINIT, NAME = N'ADMIN_backup_20071015101749', SKIP, REWIND, NOUNLOAD, STATS = 10
I get the following error
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 3, 'The system cannot find the path
specified.'
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'g:\\ADMIN\ADMIN_backup_200710151017.bak'.
Operating system error 3(error not found).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
I have also checked that the Recovery Model is set to Full
I am sure it must be a permissions thing as I can do it on the local
machine, any thoughts?
Thanks PIt looks to me like the SQL Server service account doesn't have appropriate permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:89B40417-574A-46ED-BBD8-B61E1C597024@.microsoft.com...
> Hi,
> I am trying to set up a backup maintenance plans for one of my database
> using SQL Server 2005, I have made sure that the account that I am using to
> run the job has the necessary permissions on the remote server to create
> folders as I am trying to put the backup onto a mapped drive.
> When you view the scrip it looks like the following
> EXECUTE master.dbo.xp_create_subdir N'g:\\ADMIN'
> GO
> BACKUP DATABASE [ADMIN] TO DISK => N'g:\\ADMIN\ADMIN_backup_200710151017.bak' WITH NOFORMAT, NOINIT, NAME => N'ADMIN_backup_20071015101749', SKIP, REWIND, NOUNLOAD, STATS = 10
> I get the following error
> Msg 22048, Level 16, State 1, Line 0
> xp_create_subdir() returned error 3, 'The system cannot find the path
> specified.'
> Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'g:\\ADMIN\ADMIN_backup_200710151017.bak'.
> Operating system error 3(error not found).
> Msg 3013, Level 16, State 1, Line 1
> BACKUP DATABASE is terminating abnormally.
> I have also checked that the Recovery Model is set to Full
> I am sure it must be a permissions thing as I can do it on the local
> machine, any thoughts?
> Thanks P|||Hi Tibor,
That is what I thought as well so I changed this to run under my own windows
login account which has access to everything but still get the same error.
Dont suppose you have any other ideas, just seems silly but we have had
problems here with the network guy changing permissions on certain folders.
Thanks Phil
"Tibor Karaszi" wrote:
> It looks to me like the SQL Server service account doesn't have appropriate permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:89B40417-574A-46ED-BBD8-B61E1C597024@.microsoft.com...
> > Hi,
> >
> > I am trying to set up a backup maintenance plans for one of my database
> > using SQL Server 2005, I have made sure that the account that I am using to
> > run the job has the necessary permissions on the remote server to create
> > folders as I am trying to put the backup onto a mapped drive.
> >
> > When you view the scrip it looks like the following
> >
> > EXECUTE master.dbo.xp_create_subdir N'g:\\ADMIN'
> > GO
> > BACKUP DATABASE [ADMIN] TO DISK => > N'g:\\ADMIN\ADMIN_backup_200710151017.bak' WITH NOFORMAT, NOINIT, NAME => > N'ADMIN_backup_20071015101749', SKIP, REWIND, NOUNLOAD, STATS = 10
> >
> > I get the following error
> >
> > Msg 22048, Level 16, State 1, Line 0
> > xp_create_subdir() returned error 3, 'The system cannot find the path
> > specified.'
> > Msg 3201, Level 16, State 1, Line 1
> > Cannot open backup device 'g:\\ADMIN\ADMIN_backup_200710151017.bak'.
> > Operating system error 3(error not found).
> > Msg 3013, Level 16, State 1, Line 1
> > BACKUP DATABASE is terminating abnormally.
> >
> > I have also checked that the Recovery Model is set to Full
> >
> > I am sure it must be a permissions thing as I can do it on the local
> > machine, any thoughts?
> >
> > Thanks P
>|||Alternatively, I'll suggest you to try using UNC paths instead of mapped
drives. And give it a try on your windows using Start\Run for example. If
you can connect to that path using UNC then try this way in your maintanence
plan. And as Tibor has already mentioned, ensure your job account has enough
privileges to reach that target.
--
Ekrem Ã?nsoy
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:172C2BFC-07A8-49E4-85E5-E19636744A73@.microsoft.com...
> Hi Tibor,
> That is what I thought as well so I changed this to run under my own
> windows
> login account which has access to everything but still get the same error.
> Dont suppose you have any other ideas, just seems silly but we have had
> problems here with the network guy changing permissions on certain
> folders.
> Thanks Phil
> "Tibor Karaszi" wrote:
>> It looks to me like the SQL Server service account doesn't have
>> appropriate permissions.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:89B40417-574A-46ED-BBD8-B61E1C597024@.microsoft.com...
>> > Hi,
>> >
>> > I am trying to set up a backup maintenance plans for one of my database
>> > using SQL Server 2005, I have made sure that the account that I am
>> > using to
>> > run the job has the necessary permissions on the remote server to
>> > create
>> > folders as I am trying to put the backup onto a mapped drive.
>> >
>> > When you view the scrip it looks like the following
>> >
>> > EXECUTE master.dbo.xp_create_subdir N'g:\\ADMIN'
>> > GO
>> > BACKUP DATABASE [ADMIN] TO DISK =>> > N'g:\\ADMIN\ADMIN_backup_200710151017.bak' WITH NOFORMAT, NOINIT, NAME
>> > =>> > N'ADMIN_backup_20071015101749', SKIP, REWIND, NOUNLOAD, STATS = 10
>> >
>> > I get the following error
>> >
>> > Msg 22048, Level 16, State 1, Line 0
>> > xp_create_subdir() returned error 3, 'The system cannot find the path
>> > specified.'
>> > Msg 3201, Level 16, State 1, Line 1
>> > Cannot open backup device 'g:\\ADMIN\ADMIN_backup_200710151017.bak'.
>> > Operating system error 3(error not found).
>> > Msg 3013, Level 16, State 1, Line 1
>> > BACKUP DATABASE is terminating abnormally.
>> >
>> > I have also checked that the Recovery Model is set to Full
>> >
>> > I am sure it must be a permissions thing as I can do it on the local
>> > machine, any thoughts?
>> >
>> > Thanks P|||Your prior post said "the account that I am using to run the job", which isn't the same thing as the
SQL Server service account.
Just to be certain, try running both SQL Server as well as Agent under the same service account.
Make the job owner sysadmin. If that work, but security isn't as you like it, you at least have
something to work from.
Also, Ekrem picked up on a good thing regarding mapped drives. use UNC instead. And, I noted two
backslashes in a path, you might want to correct that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:172C2BFC-07A8-49E4-85E5-E19636744A73@.microsoft.com...
> Hi Tibor,
> That is what I thought as well so I changed this to run under my own windows
> login account which has access to everything but still get the same error.
> Dont suppose you have any other ideas, just seems silly but we have had
> problems here with the network guy changing permissions on certain folders.
> Thanks Phil
> "Tibor Karaszi" wrote:
>> It looks to me like the SQL Server service account doesn't have appropriate permissions.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:89B40417-574A-46ED-BBD8-B61E1C597024@.microsoft.com...
>> > Hi,
>> >
>> > I am trying to set up a backup maintenance plans for one of my database
>> > using SQL Server 2005, I have made sure that the account that I am using to
>> > run the job has the necessary permissions on the remote server to create
>> > folders as I am trying to put the backup onto a mapped drive.
>> >
>> > When you view the scrip it looks like the following
>> >
>> > EXECUTE master.dbo.xp_create_subdir N'g:\\ADMIN'
>> > GO
>> > BACKUP DATABASE [ADMIN] TO DISK =>> > N'g:\\ADMIN\ADMIN_backup_200710151017.bak' WITH NOFORMAT, NOINIT, NAME =>> > N'ADMIN_backup_20071015101749', SKIP, REWIND, NOUNLOAD, STATS = 10
>> >
>> > I get the following error
>> >
>> > Msg 22048, Level 16, State 1, Line 0
>> > xp_create_subdir() returned error 3, 'The system cannot find the path
>> > specified.'
>> > Msg 3201, Level 16, State 1, Line 1
>> > Cannot open backup device 'g:\\ADMIN\ADMIN_backup_200710151017.bak'.
>> > Operating system error 3(error not found).
>> > Msg 3013, Level 16, State 1, Line 1
>> > BACKUP DATABASE is terminating abnormally.
>> >
>> > I have also checked that the Recovery Model is set to Full
>> >
>> > I am sure it must be a permissions thing as I can do it on the local
>> > machine, any thoughts?
>> >
>> > Thanks P