Restore database error.

  • forsqlserver (6/1/2011)


    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%5B/quote%5D

    Nice article ...thanks

    Regards
    Sushant Kumar
    MCTS,MCP

  • on the dev server :-

    kernel memory (k):-

    total 321692

    paged 121144

    Non paged 200548

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • Dear Sushant,

    Ypur paged memory is 120 MB Please increase it upto 170 MB then u will not face this error.

    Thanks

  • please restore the DB using MOVE option, as ur datafiles are not corectly pointed.

    As per suggestion by Perry Whittle.... kindly try let us know

  • forsqlserver (6/2/2011)


    Dear Sushant,

    Ypur paged memory is 120 MB Please increase it upto 170 MB then u will not face this error.

    I guess u hit the bull's eye...because I checked my prod server and it has 190MB( kernel paged)

    Can i also know, How to increase it.

    Thanks.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply