November 1, 2010 at 1:17 pm
We have a new network share to backup sql files to. We are using the destination format \\10.1.20.50\sqlbackups\Production\foldername. We can get all the backup scripts to backup to this folder using IP address, with the exception of one server instance. That is, we currently use one elevated login on all database instances and 6 backup but the 7th fails with the error.
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 161, 'The specified path is invalid.'
The server that fails is named crabnebula
If I RDP to crabnebula server and try to create folder using winsql sql serverr service account (which has same rights in sql as in other instances and is admin on this server as on the other servers)
EXECUTE master.dbo.xp_create_subdir '\\10.1.20.50\sqlbackups\NonProduction\CRABNEBULA\1'
the command fails
But I can logon to another server with the same login and same rights on sql and server, one of the 6 that work, and execute the command pointing to crabnebula's folder, and the folder is created: '\\10.1.20.50\sqlbackups\NonProduction\CRABNEBULA\1'
Any ideas???
November 2, 2010 at 7:38 am
danfugett (11/1/2010)
We have a new network share to backup sql files to. We are using the destination format \\10.1.20.50\sqlbackups\Production\foldername. We can get all the backup scripts to backup to this folder using IP address, with the exception of one server instance. That is, we currently use one elevated login on all database instances and 6 backup but the 7th failswith the error
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 161, 'The specified path is invalid.'
\\10.1.20.50\sqlbackups\NonProduction
\\10.1.20.50\sqlbackups\Production
are you maybe using the wrong path in the backup script on server crabnebula?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2010 at 4:34 am
What user account is the actual SQL Server service running under on the machine that works compared to the machine that doesn't?
May 2, 2011 at 3:21 pm
Make sure that you are using domain user account with access to the path specified. Don’t use Local System account.
May 5, 2011 at 11:24 am
If the server registered in Active Directory, there should be a computer account for the server, and this account is used whenever Local System is requesting access to other services and servers in the domain. So you can use the Local System account for the SQL Server service and still be able to access shares on other computers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply