• Pulivarthi Sasidhar (1/22/2015)


    Below is for your information..... It may be depends on Server Envioronmrnt also....

    1. In-place upgrade

    Easy to implement

    no need to configure Applications...

    No Backup & Restore

    No logins for Users & Apps and etc...

    2. Side-by-Side upgrade

    Complete rebuild from Installation and then restore the Backups of SQL 2008 and Restore logins

    Configure all applications and etc

    Complete cross check for each & every step...

    I don't agree completely with this assessment at all.

    You're modifying your databases in place while you modify your server in place. If either goes wrong, you've lost everything. That's the most important place to have good backups. Also, in terms of configuring Applications, I assume you mean changing connection strings. You're right, but any upgrade will require you to test apps, so the cross check on each and every step that you're "avoiding" with the in place upgrade, you still have to do all of it.

    The side-by-side upgrade is a lot more work, but a lot safer. If anything goes wrong, the old server is sitting there waiting for you. The in-place upgrade is less work, but is also inherently less safe. If anything goes wrong, you may have to rebuild your server from scratch as well as restore all your databases.

    "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