May 30, 2011 at 11:57 pm
SKYBVI (5/30/2011)
and the bak file is just 150 gbRegards,
Sushant
@Sushant have you checked the maxsize for restoration?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 30, 2011 at 11:58 pm
SKYBVI (5/30/2011)
When iam restoring via this query :-RESTORE DATABASE RTW
FROM DISK = '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'
WITH MOVE 'GPSRTWDat.mdf' TO 'E:\MSSQL\Data\RTW.mdf',
MOVE 'GPSRTWLog.ldf' TO 'E:\MSSQL\Data\RTW.ldf',
STATS=5
It does 30% and then throws this ERROR:--
30 percent processed.
Msg 3203, Level 16, State 2, Line 1
Read on "\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak" failed: 1130(Not enough server storage is available to process this command.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Regards,
Sushant
Which Server OS you are having?
May 31, 2011 at 12:06 am
SKYBVI (5/30/2011)
not much on the server as its newly build ...it hasMicrosoft dynamics Great Plains
SQL server 2005
Acronis true image server and
symantec endpoint protection
Yes, im connected to right server for restoration.
How to know if server has permissions to write on disk? ( isn't that self built )
Regards,
Sushant
I would also like let you know that if you don't have SQL sever 2005 SP2 then Please update it ,cause there was bug related to issue Reported to microsoft and they had correct it in SQL server 2005.
here is link
http://support.microsoft.com/kb/921896
http://support.microsoft.com/kb/917885
Let me know if it works for you.
May 31, 2011 at 8:57 am
@ all
thanks guyz,
I again tried restoring thru query...
and this time it got restored...it took 7 hrs to retore 300gb db...
its too much time i guess....but then all's well tht ends well...
Maybe problem was some network glitch wich didnt happen this time around..
It will remain a mystery though 🙁
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 31, 2011 at 9:11 am
SKYBVI (5/31/2011)
@ allthanks guyz,
I again tried restoring thru query...
and this time it got restored...it took 7 hrs to retore 300gb db...
its too much time i guess....but then all's well tht ends well...
Maybe problem was some network glitch wich didnt happen this time around..
It will remain a mystery though 🙁
Regards,
Sushant
So you plan to never update that DB again? Strange politic for dev environement!
May 31, 2011 at 9:29 am
Ninja's_RGR'us (5/31/2011)
SKYBVI (5/31/2011)
@ allthanks guyz,
I again tried restoring thru query...
and this time it got restored...it took 7 hrs to retore 300gb db...
its too much time i guess....but then all's well tht ends well...
Maybe problem was some network glitch wich didnt happen this time around..
It will remain a mystery though 🙁
Regards,
Sushant
So you plan to never update that DB again? Strange politic for dev environement!
The real reason for that error, i couldn't know...Wat else Should i do?
Regards
Sushant Kumar
MCTS,MCP
May 31, 2011 at 9:33 am
What did you find in the windows and sql logs?
May 31, 2011 at 9:54 am
Ninja's_RGR'us (5/31/2011)
What did you find in the windows and sql logs?
Windows logs :--
BackupMedium::ReportIoError: read failure on backup device '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'. Operating system error 1130(Not enough server storage is available to process this command.).
SQL logs:--
Message
BackupMedium::ReportIoError: read failure on backup device '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'. Operating system error 1130(Not enough server storage is available to process this command.).
Same errors
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 31, 2011 at 9:56 am
I've found a few links on google about this error... at least you have other options if it occurs again.
May 31, 2011 at 10:02 am
Ninja's_RGR'us (5/31/2011)
I've found a few links on google about this error... at least you have other options if it occurs again.
on google i found abt IRPStack and changign registry, i talked with network engineer abt htt and he said that its not because of tht.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 31, 2011 at 3:16 pm
also to keep in mind: you can "restart" a restore !
restore database ...
with
, RESTART
I recall using this a couple of time on win2003 os with sql2005sp2 with a bak file of +/- 100GB failing with the error you mentioned.
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
May 31, 2011 at 4:03 pm
What was the source of the problem?
June 1, 2011 at 7:09 am
ALZDBA (5/31/2011)
also to keep in mind: you can "restart" a restore !
restore database ...with
, RESTART
I recall using this a couple of time on win2003 os with sql2005sp2 with a bak file of +/- 100GB failing with the error you mentioned.
What's the difference if i manually, start the restore again, once it gets failed.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
June 1, 2011 at 2:58 pm
start from scratch or restart form the point where it failed ...
I don't know what the effect is on the "network" problem, but at one time when I had this issue, I've only been able to get the db restored using the restart option. ( After a number of attempts just launching a full restore, I tried a restarted restore and needed to do that two times until it succeeded )
I've only had this issue on one case and didn't encounter it afterward.
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
June 1, 2011 at 11:52 pm
Please paste the paged memory of Dev server.
Please refer the link....for error 1130 which clearly says the dependency of 160 MB of paged memory if server is 2003.
http://support.microsoft.com/kb/304101
Thanks
Viewing 15 posts - 16 through 30 (of 34 total)
You must be logged in to reply to this topic. Login to reply