Post reply

HELP!!!!!! Need to move sql 7 from NT box to NT box

  • March 11, 2004 at 12:47 pm

    #82243

    People I need help and seriously quickly I have to move a sql7 server from one NT4 box to a new NT4 box. Just one little problem. I know jack didly nothing about sql and I mean absolutly nothing. Somehow somewhere I need a detailed step by step guide on how to do this without destroying the companies entire database. I know you are all busy people but damn I will be eternally gratefull for some help on this topic.

    So far I have duplicated the old setting on the new box. The new box is setup as a BDC to copy user configuration information. And I have updated it with same service pack and patches. Hard drive structure was also duplicated. The aim is to move all the info from the old box to the new one and then retire the old box.

     

    PLEASE HELP

     

  • March 11, 2004 at 1:02 pm

    #498361

    I've done this before...Like This:

    1.  Shut down the SQL Services MSSQLSERVER and SQL Server Agent on both boxes.

    2.  COPY the database files (.mdf .ndf, .ldf) from old server to new server, placing them in the same directory names on new server.  Master and msdb should overwrite on new server, and tempdb doesn't need to be copied. 

    3.  Start the services back up.  Voila!

    If something goes wrong (which it didn't for me), since you did a copy, the old server is still operational.  This method can take some time if the databases are large and the network speed is not...but using this method you can run a full "test" of the process during off-hours without affecting the old server.

    4.  You'll need to do some hand-checking for hard-coded server names in the code and in DTS packages, etc. and backups, if to disk shares, may need to change.

    This can be a tricky operation...should have some SQL experience to avoid pitfalls.

    Steve

  • March 11, 2004 at 2:06 pm

    #498381

    after I (hopefully successfully copied the database with info supplied) TX muchly. I intend to take of the PDC and promote the BDC as well as rename the BDC to the name of the removed PDC. Will this sort out identification issues like hard coded server names etc.????????????

  • March 12, 2004 at 5:51 am

    #498477

    Nope.  In fact, making your SQL box also a PDC or BDC isn't a good idea...too much network traffic...

Viewing 4 posts - 1 through 3 (of 3 total)

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