Post reply

sqlsever 2005 upgradation

  • September 23, 2010 at 3:26 am

    #142085

    Hi All,

    we have a sqlserver 2005 box. we just restored from sqlserver 2000 backup to 2005.

    and create a logins,users,roles and given permissions to those users.. Configurations are same

    my question is,

    Is there any drawbacks, we can use as a production server

    if any drawbacks are there.. kindly let me know..

    Thanks & Regards

    Balaji.G

  • September 23, 2010 at 3:32 am

    #1226170

    hi,there should not be any drawback but you need to change the database compatability level from 80 to 90.

    Regards,

    Karthik

  • September 23, 2010 at 4:16 am

    #1226195

    Hi Karthick,

    Thanks fo your instant reply ...

    Can you tell me.. which is the best way to upgrade from sql 2000 to 2005

    a) simply we restored 2000 backup and chage the compatability level (or)

    b) can we use inplace upgradation (or)

    c) can we use side by side upgradation

    Thanks & Regards

    Balaji.G

  • September 23, 2010 at 6:19 am

    #1226254

    hi, check on Microsoft SQL Server 2005 Upgrade Advisor which helps you to identify the best way of upgrade.

    Download using the below link.......

    http://www.microsoft.com/downloads/en/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

    Regards,

    Karthik

  • September 23, 2010 at 7:32 am

    #1226316

    Easiest way to upgrade is a backup/restore and then change compatibility.

    Test it first outside production to make sure there are not depreciated SQL used.

    Since you are busy upgrading, you might as well go right to SQL 2008 R2 🙂

  • September 23, 2010 at 8:34 am

    #1226369

    @ balaji

    The drawback which i noticed is that some users wont be able to login into the databases after you restore the database to another server.

    That happens due to the mismatch of the SID's of users, which then has to be fixed.

    Also, before doing upgradation, backup all your user and system databases.

    First run the upgrade advisor to see any issues with the system or any thing needs to be resloved.

    After that you can proceed the upgrade.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • September 23, 2010 at 8:54 am

    #1226390

    Just checking in to show support for the word "upgradation". I think we should make that the standard technical term.

    I am not kidding or teasing.

Viewing 7 posts - 1 through 6 (of 6 total)

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