Post reply

Server Crash

  • February 1, 2005 at 8:11 am

    #163717

    I have SQL 7 running on a NT 4.0 server. Last night the NT box crashed, which we are now in the process of re-installing. My question is: I have my .mdf and .log files but no good backup from last night (I would lose all data from yesterday), can I restore somehow from just the mdf and log files? Any help would be greatly appreciated.

  • February 1, 2005 at 10:04 am

    #539979

    First make a copy of the MDF AND LDF to somewhere safe.

    Then look at Attach, either via EM or SP_Attach.  Check BOL for details.

     


    KlK

  • February 1, 2005 at 10:19 am

    #539987

    Thanks for the response. Hopefully all will be well shortly.

  • February 1, 2005 at 4:06 pm

    #540056

    I was able to get the database back up and running. I see a problem with the users, is the only way to resolve this to run:

    sp_dropuser 'user' and then set them up again?

    Thanks again for the direction.

  • February 1, 2005 at 4:28 pm

    #540060

    Look up SP_CHANGE_USERS_LOGIN 'Auto_Fix', 'user'

    I think if you add it as a SERVER login, then run the above inside the db in ? it should fix it.


    KlK

  • February 2, 2005 at 12:18 am

    #540089

    If you have reinstalled exactly to the situation like before the crash, then you can just copy all mdf, ldf, ndf files (also master and msdb if you have kept the servername) to their exact locations.

    This way, you will keep userinfo, ... OK

    Remember to keep a safe copy of all your mdf, ldf, ndf files.

    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 6 posts - 1 through 5 (of 5 total)

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