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 12»»

Upgrade from Sql 2003 to Sql 2008 Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 6:08 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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,
Post #1472072
Posted Wednesday, July 10, 2013 6:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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
Post #1472081
Posted Wednesday, July 10, 2013 7:56 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 6:05 AM
Points: 40,258, Visits: 36,681
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 2008, MVP
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

Post #1472156
Posted Wednesday, July 10, 2013 10:02 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Sorry Shaw, Its windows 2003 but sql server 2005 and upgrading to 2008 R2.


Thanks.


Post #1472421
Posted Thursday, July 11, 2013 1:45 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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.

Post #1472758
Posted Monday, July 15, 2013 6:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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.

Post #1473606
Posted Monday, July 15, 2013 9:06 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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!



Post #1473957
Posted Tuesday, July 16, 2013 1:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 6:05 AM
Points: 40,258, Visits: 36,681
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 2008, MVP
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

Post #1474010
Posted Wednesday, July 17, 2013 3:34 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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!

Post #1474821
Posted Wednesday, July 17, 2013 4:17 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 6:05 AM
Points: 40,258, Visits: 36,681
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 2008, MVP
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

Post #1474830
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse