Not able to take one db backup on network location where as other db backup taking place of the same server and on the same network location

Question

Not able to take one db backup on network location where as other db backup taking place of the same server and on the same network location

Pkrana1980

SSC-Addicted

Points: 462
More actions
June 24, 2011 at 8:07 am

#242594

Not able to take one db backup on network location where as other db backup taking place of the same server and on the same network location
Please find error message below
"Msg 3202, Level 16, State 2, Line 1
Write on "\etworklocation\dbname_full.bak" failed: 64(error not found)
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "\etworklocation\dbname_full.bak" 64(error not found).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

Parveen-288612 (6/24/2011)
Not able to take one db backup on network location where as other db backup taking place of the same server and on the same network location
Please find error message below
"Msg 3202, Level 16, State 2, Line 1
Write on "\etworklocation\dbname_full.bak" failed: 64(error not found)
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "\etworklocation\dbname_full.bak" 64(error not found).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."

Please check System Event Log for complete error message.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

How large is the database that fails to backup?

How much free space is available on the network location?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Verify that the mapped drive is still available if not re-map.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 4

"\etworklocation\"

Check above location is accessible locally from where the backup has been taken ? OR is there any recent change in permissions?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Pkrana1980 SSC-Addicted Points: 462 More actions · Answer 5

Hi ,

db size is around 8 GB and there is around 300 GB free space available on network location.

Just for information I am able to take backup of other dbs of same server on the same network location.

Regards,

Parveen

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Parveen-288612 (6/24/2011)
"\etworklocation

Is not a valid UNC Path.

Also make sure that the SQL server Agent Account has permissions to the correct path.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

aatishpatel SSC Veteran Points: 232 More actions · Answer 7

are you using the SQL Agent to run the job. If yes use the query analyzer to tun the backup script.

also see if you backup folder might need the same account as the sql agent account

Thank you.
Aatish Patel

Pkrana1980 SSC-Addicted Points: 462 More actions · Answer 8

Hi there was sql agent job which execute full backup job, but it start failing then I execute backup command in query analyzer but still it failed with error message as I posted earlier.

Please see error log below.

BackupMedium::ReportIoError: write failure on backup device '\\sqldump01\prisql01\vlabDatadb_F.bak'. Operating system error 64(error not found).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

'\\sqldump01\prisql01\' does not sound like a valid Server & Path (Share).

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/