Post reply

After migration , is it possible to access migrated old server

  • June 3, 2010 at 12:34 am

    #221699

    i have upgraded sql server from 2000 to 2005 so now is there a way to connect 2000 again?

    anyone please help me in urgent

  • June 3, 2010 at 1:40 am

    #1175726

    If you have done In Place upgrade you cant access, if you have done side by side upgrade then you can.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • June 3, 2010 at 6:47 am

    #1175900

    I'm with the previous poster. If you've upgraded the server itself, then no, you can't reconnect to the 2000 instance because it's not a 2000 instance any more. If you've upgraded by moving the database to a new server, just connect to the old one.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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