Restore database error.

  • SKYBVI (5/30/2011)


    and the bak file is just 150 gb

    Regards,

    Sushant

    @Sushant have you checked the maxsize for restoration?

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • 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?

  • SKYBVI (5/30/2011)


    not much on the server as its newly build ...it has

    Microsoft 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.

  • @ 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

  • SKYBVI (5/31/2011)


    @ 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

    So you plan to never update that DB again? Strange politic for dev environement!

  • Ninja's_RGR'us (5/31/2011)


    SKYBVI (5/31/2011)


    @ 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

    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

  • What did you find in the windows and sql logs?

  • 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

  • I've found a few links on google about this error... at least you have other options if it occurs again.

  • 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

  • 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

  • What was the source of the problem?

  • 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

  • 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

  • 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