Posted - 07/05/2013 : 14:19:28
I am trying to create a backup of a SQL database to a network drive (\\10.11.2.105\bus).
I am currently mapped to the drive from the Windows server where SQL Server is on.
The SQL Server (MSSQLSERVER) service Log On As column is the login to the Windows server.
The following is the SQL being used in the SQL Query window:
BACKUP DATABASE Training TO DISK = '\\10.11.2.105\bus\Training.bak' WITH INIT
I am receiving the following message:
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\10.11.2.105\bus\Training.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Per my research, SQL Server needs to point to the map drive? I have not found where to do that.
How do I have SQL Server point to the network drive?