After migration , is it possible to access migrated old server

  • 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

  • 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

  • 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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

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