Post reply

problem with database restoring itself?

  • April 23, 2008 at 1:35 pm

    #186946

    Afternoon,

    We have a server that crashed and stopped responding when it came back up. I didn't hear about it until the network admin restarted it again 🙂 Now its stuck in restore and obviously offline. Is there anything I can do to speed it up its been at it over an hour and a half. I didn't initiate the restore and neither did the admin.

    any thoughts or suggestions would be great.

    Laura

  • April 23, 2008 at 5:02 pm

    #806341

    Can you please explain bit more about the database restore issue part. I couldnt understand your problem exactly.

    Thanks
    Jay
    http://www.sqldbops.com

  • April 23, 2008 at 5:43 pm

    #806348

    I really dont know how to describe it. When it came back up it said it was in the middle of a restore. I did not initiate it nor did the admin. It was restoring for over an hour and a half and was still working on i when I had to leave.

    I'm not as familiar with 2005 as I am with 2000 and I have never seen a database start restoring itself. Is that a "feature"?

    Thanks

    Laura

  • April 24, 2008 at 12:02 am

    #806371

    The situation seems to be as follows -

    A database activity was active, which might have slowed down the server. It was very risky to restart the server, as some data might be lost already, and there is a fair bit of chance for the database to be corrupted.

    Note: Next time use DAC (Dedicated administrator connection) is you find the system to be slow or hanged. This is a new feature from SQL Server 2005 onwards.

    Each time the server is started and eventually the Database Server is started, MS SQL Server checks for the consistency of the databases and any interrupted renewable job; and if any problem is found, tries to rectify them. Probably, your Server is in the same mode.

    If the restoring tag is there for quite a long time, depending upon the size of the database, try restarting the Database Server Service (Not the System) once more. If that does not work, you are into trouble.....

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.

  • April 24, 2008 at 12:10 am

    #806372

    Check the database's status in the sys.databases view. Is it restoring or recovering?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 24, 2008 at 5:06 am

    #806464

    Thanks for all your help. It is much appreciated.

  • April 24, 2008 at 5:27 am

    #806476

    We are always here to help you..........we love problems.........it lets us know more........and to add, Gila Monster is one of the best and cool headed I have seen out here.......for you start posting and have fun......

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.

  • April 24, 2008 at 5:30 am

    #806477

    We are always here to help you..........we love problems.........it lets us know more........and to add, Gila Monster is one of the best and cool headed I have seen out here.......for you.... start posting and have fun......;)

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.

Viewing 8 posts - 1 through 7 (of 7 total)

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