September 26, 2011 at 11:14 am
We migrated our SQL 2005 server to a new 64 bit Windows Server 2008 box. Now, when I backup 500+ MB files to a network share, I receive the below error several minutes:
Msg 3271, Level 16, State 1, Line 2
A nonrecoverable I/O error occurred on file "\\<SERVER>\<SHARE>\<DB>.bak:" 64(The specified network name is no longer available.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
In the Application Logs I see the following:
BackupDiskFile::RequestDurableMedia
\\<SERVER>\<SHARE>\<DB>.bak
64(The specified network name is no longer available.)
22470000100000000A0000004E0047005300520056005200530051004C00000000000000
This worked before the migration. So I do not believe this is a problem with the network or the file server. I also tried on another file server with no success. When I run a backup locally, it flies and works flawlessly. This is true for Full and Differential backups.
I read a few things pointing to Disabling Network Redirector File Caching and playing with parameters on the LanmanWorkstation registry entry, but nothing specific to WS 2008. Any thoughts?
Thank you in advance!
September 26, 2011 at 12:50 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1181257-357-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply