September 26, 2011 at 12:37 pm
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 4:09 pm
I found asolution. You need to add a DWORD "SessTimeout" to HKLM\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters with a decimal value in seconds. I used 300.
If anyone has something more elegant I'd love to entertain!
Thanks anywayz!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply