January 22, 2009 at 10:05 am
Hi Guys,
I always use to restore our Test server from the network successfully, But now when i am getting this error message, The process fails at the 20% mark with a error message as shown below, DB size is 250GB on sql server 2005 sp2 & windows 2003 enterprise version sp2.
System.Data.SQLClient.SQLError: Read on '\\ServerName\Directory\Folder\File.bak' failed: 1130(Not enough server storage is available to process this command.) (Microsoft.SQLServer.Smo)
Can some one please Let me know what to do, i tried two times same result, But now i did change this from seeing a forum,
Click on Start, Run, Regedit
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
Click Edit, point to New, and then click DWORD Value.
Type IRPStackSize , and then press ENTER to name the value.
Note: Type IRPStackSize exactly as it is displayed.
The value name is case sensitive.
Radix: Decimal
Value data: 20 (increase by increments of 2 if the problem persists)
WARNING: Do not set to 32 Decimal or higher which might cause network related issues.
When you get a chance, stop and restart the server service.
Note: When you stop the server service, your network shares will be temporarily unavailable.
So again started by changing this settings, will see whether it will restore successful or not.
Thanks
March 11, 2009 at 1:28 pm
Did this resolve it?
July 5, 2010 at 6:06 am
Any news on this matter ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply