on 02-03-2015 6:02 AM
Hi friend , I want to take backup EHP 7 at Network location .
I have Read/ Write Permission to that location.
But SQL Server Management is giving following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Backup failed for Server '#######'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).12021...
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot open backup device '\\serv###\SAP_Media_and_Backup\Backup\$$\$$.bak'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)
BUTTONS:
OK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Operating system error 5(Access is denied.
This clearly says that you don't have access to the network drive.
Did you tried mapping the network drive?
regards,
pavan
Yes.. I can create a folder/file on that drive.
Use xp_cmdshell extended stored procedure to map network drive inside of MS SQL.
Usage:
EXEC xp_cmdshell 'NET USE Z: \\networkpath password /USER:username'
Follow the below link for further info.
Backup and Restore SQL Server Database to a network shared drive - Varun Dhawan's Blog - Si...
Refer this and see if that helps.
http://support.microsoft.com/kb/207187
I tried all that. Everything is as per the standard rule.
Might be internal Network issue.
So i am switching to another location.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.