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 |
|
usdasqldba
Starting Member
4 Posts |
 Posted - 2007-08-13 : 17:10:21
|
| I am trying to do a network backup to our backup network, but am getting errors.I run the command via QA BACKUP DATABASE master TO DISK = '\\myserver\myshare\master.bak' WITH INITI get the following errors:Server: Msg 3201, Level 16, State 1, Line 1Cannot open backup device '\\myserver\myshare\master.bak' '. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.Things I know:The server I am trying to backup to is a Media server in the backup network (Vlan2). My SQL DB server is in VLan4. I do have port 1433 open to the backup network.I can ping the backup serverI can use explorer and connect to the backup server pathI can map a drive to the backp server, but the backup still fails.My SQL Server/Agent acct is a domain acct with perms to the share on the backup server.I have no idea why this does not work! :-) Any thoughts on my issue? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 23:00:25
|
| Did you see the file there? Rename it then try backup again if so. |
 |
|
|
usdasqldba
Starting Member
4 Posts |
Posted - 2007-08-15 : 12:24:21
|
| no files exist in the path |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-15 : 18:24:20
|
| What did you find when you followed this suggestion from the error message?"See the SQL Server error log for more details."CODO ERGO SUM |
|
|
|
marbos
Starting Member
7 Posts |
Posted - 2007-08-16 : 16:24:02
|
| The reason you are getting this error is most likely because both the SQL Server Service and SQL Server Agent must be running under an account that have permissions on the share you are trying to dump to. This is the most common reason. |
|
|
|
|
|
|
Network Backups