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


Upgrade from Sql 2003 to Sql 2008


Upgrade from Sql 2003 to Sql 2008

Author
Message
poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
Hi,
We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to be prepared and how to do as I will doing very first time.

We have sql 2003 - on windows 2003 server with 4 CPU and 4 GB Memory.
We have almost 12 Databases and biggest DB is around 250 GB which is also feed by Replication DB as subscriber and Publisher resides on 3rd party.

1) What should be the new hardware and server we should configure?
2) What other things we need to consider?
3) What's the proper steps to migrate/upgrade DB?

Thanks,
bitbucket-25253
bitbucket-25253
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8063 Visits: 25280
Suggest you read this: (SQL Server Upgrade Advisor) 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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)

Group: General Forum Members
Points: 91361 Visits: 45285
poratips (7/10/2013)
We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to be prepared and how to do as I will doing very first time.

We have sql 2003 - on windows 2003 server with 4 CPU and 4 GB Memory.


There's no such thing as SQL 2003. Are you upgrading from SQL Server 2000 or SQL Server 2005?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
Sorry Shaw, Its windows 2003 but sql server 2005 and upgrading to 2008 R2.


Thanks.
poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
One more correction:

we have sql server 2005 - 9.00.4060.00 (intel x86) windows standard edition on windows NT 5.2 (build 3790: service pack 2).
I will be also running Sql 2008 Upgrade Advisor.
poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
We are migrating from Sql 2005 standard edition to Sql 2008 R2 enterprise edition.
From your experience, if you have any better tips, appreciate it.
poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
Hello,
Is it virtualization is good or stand alone server hardware is good?

Is it 8 core/CPU is enough?


Thanks and appreciate your response!
GilaMonster
GilaMonster
SSC Guru
SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)

Group: General Forum Members
Points: 91361 Visits: 45285
poratips (7/15/2013)
Is it virtualization is good or stand alone server hardware is good?


Virtualisation's fine, stand alone hardware's fine, depending on what you're doing

Is it 8 core/CPU is enough?


No way to answer that, to identify the CPU required would require careful benchmarking of the current server, an extrapolation of growth patterns and a decision based on that data.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


poratips
poratips
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 653
Thanks Gail.
We have one Replication DB which is big - 250 GB and others are smaller DB.
Replication runs every few minutes and few batch jobs we are running during day time and off hours.

We have around 12 -15 DBs.
We are running monthly reports and that time we are having some of the long wait and blocking issue.

Do you have any suggestion which might help to decide how many processor could benefit?

For Virtualization, i am little worried as it will be performance issue?

From your experience, any criteria or standard we should take in consideration to go with either Virtualization or Stand alone?

Thanks for help!
GilaMonster
GilaMonster
SSC Guru
SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)

Group: General Forum Members
Points: 91361 Visits: 45285
poratips (7/17/2013)
Do you have any suggestion which might help to decide how many processor could benefit?


Benchmark the servers, see what they currently use, plan future growth, that gives you somewhere to start with processor need

For Virtualization, i am little worried as it will be performance issue?


And you've tested and confirmed there's a noticable, measurable performance degradation from virtualisation?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


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