SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrade production Server - SQL 2005 to SQL 2008 - inplace upgrade


Upgrade production Server - SQL 2005 to SQL 2008 - inplace upgrade

Author
Message
SteveEClarke
SteveEClarke
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1279 Visits: 457
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.
bitbucket-25253
bitbucket-25253
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15279 Visits: 25280
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
SteveEClarke
SteveEClarke
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1279 Visits: 457
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.
sql-lover
sql-lover
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4353 Visits: 1930
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.
SteveEClarke
SteveEClarke
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1279 Visits: 457
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search