Post reply

server upgrade

  • April 9, 2011 at 7:51 am

    #234683

    Hello All,

    I have to upgrade my clients SQL server 2000 and SQL server 2005 to SQL server 2008 R2

    please tell me, should i do this with upgrade wizard or i must uninstall SQL server 2000 and SQL server 2005 and then install SQL server 2008 ?

    I want to retrieve all my login and SQL jobs ? how is this possible

  • April 9, 2011 at 8:01 am

    #1309538

    You could use the upgrade assistant. I would look into doing a side by side upgrade so as to have a fallback option.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 9, 2011 at 8:04 am

    #1309540

    thanks for the post

    upgrade assistance may help us in choosing right configuration for upgrade.

    but i m more concerned with my current databases, logins and sql jobs.

    if i upgrade to SQL server 2008 R2 , do i get all the stuff or i may have to reconfigure those things again ?

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

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