Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Upgrade production Server - SQL 2005 to SQL 2008 - inplace upgrade Expand / Collapse
Author
Message
Posted Friday, May 3, 2013 5:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 3:18 AM
Points: 177, Visits: 418
Hi All,

Can I confirm that I have the process correct and that I have not missed anything ?

I am currently running SQL Server 2005 and want to upgrade to 2008/R2 -

I am running several databases, with triggers and Stored Procedures - also Maintenance Tasks.

So ...
Backup the Databases
Backup / Document Triggers
Backup / Document Stored Procedures
Backup / Document Maintanance Tasks
Backup / Document Agent Jobs

Install Sql 2008 as an upgrade

Check DB integrity
Check T / SP / MT / AJ from above
check ERP system - functions in the same way and privilages have not been compromised during the upgrade.


I think this should cover it ?



________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1449129
Posted Friday, May 3, 2013 6:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Might I suggest using the UPGRADE ADVISOR and carefully reviewing the results

upgrade advisor is available at;

http://www.microsoft.com/en-us/download/details.aspx?id=11455


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1449160
Posted Friday, May 3, 2013 6:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 3:18 AM
Points: 177, Visits: 418
After running the advisor all looks well.

Have run the upgrade on the test envoironment and again that has worked well - so planning on doing the Production server.

A very easy process by Microsoft.


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1449168
Posted Friday, May 3, 2013 7:34 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 411, Visits: 1,317
Did you test your software against SQL2008? There were some T-SQL changes on SQL2008 and deprecated features. You need to ensure your T-SQL code behind will also work or was changed accordingly.

A useful link:
http://msdn.microsoft.com/en-us/library/ms143532(v=sql.100).aspx

I actually remember few years ago, when I helped with an in-place upgrade, an old MS style join got broken in the code. I do not remember if it was when moving from 2000 to 2005 or 2005 to 2008. Long story short, the code was not tested by the developers and those joins stopped working.
Post #1449194
Posted Friday, May 3, 2013 7:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 3:18 AM
Points: 177, Visits: 418
Hi - yes the software is fully compatible with 2008 and 2012 - there are no changes out the box as it runs on 2005 ->

I have checked my scrips and generated views - without any issues - so am happy.

Thanks


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1449198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse