Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
userSQL
Starting Member
3 Posts |
 Posted - 2013-07-05 : 14:19:28
|
| Hi,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 INITI am receiving the following message:Msg 3201, Level 16, State 1, Line 1Cannot open backup device '\\10.11.2.105\bus\Training.bak'. Operating system error 5(Access is denied.).Msg 3013, Level 16, State 1, Line 1BACKUP 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?ThanksMike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Backing up SQL database to network drive