Post reply

how to get sql 7 db back after server name change

  • December 7, 2004 at 4:19 pm

    #87211

    help! had to change server name in hurry and have got the 'corrupt' db message.

    How to change sql so it'll work?

    NT4/sql7

  • December 7, 2004 at 6:24 pm

    #532957

    I think your database is not really corupt, It seems that it wants you to run re-installation of sql 7 again(everytime you change name to a server).  It is ok, just do it, and then after a couple of minutes it said, Finish.  You then could connect to your database.  Besure to redifine your local server name and then reboot.

    select @@servername  will give you your old server name.

    After the reboot, it will give you the new server name.

     

    Good luck.

Viewing 2 posts - 1 through 1 (of 1 total)

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