| Author |
Topic |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-07-10 : 08:13:29
|
| 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.Hello,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, |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-10 : 09:05:49
|
quote:
Originally posted by poratips
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.Hello,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,
Sounds like you are talking about upgrading from Windows Server 2003 to Windows Server 2008, because there is no version of SQL Server labelled "SQL 2003". SQL Versions are SQL 2000, SQL 2005, SQL 2008 and so on.I can't comment much about what you need to do to upgrade the Windows Server system. But, if you are upgrading your SQL Server installation, there are lot of resources on MSDN, including an upgrade advisor which you can download here: http://www.microsoft.com/en-us/download/details.aspx?id=11455 |
 |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-11 : 00:05:42
|
| James,Thanks for pointing out, I am upgrading from Sql server 2005 to sql server 2008 on windows server 2003, we also thinking to virtulization. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-11 : 09:09:10
|
| Checkout the URL that I posted earlier. Microsoft makes upgrading really easy and predictable with all the tools and guidance they are offering. (Well, I shouldn't say any upgrade is "easy") |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-11 : 16:20:57
|
| Thanks James.I have also downloaded Sql Upgrad Advisor and run it.I am looking more from your experience to implement and build new server hardware. |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-15 : 08:06:13
|
| I appreciate if you have better tips from your experience which help me. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-15 : 08:25:35
|
| I don't have many experiences to relate, because couple of times when I have done the upgrade, they went smoothly without a hitch. In addition to going through the documentation Microsoft provides, couple of things you do want to make sure you do are:1. Take backup of all your databases (and restore them somewhere so you know you can successfully restore) before you start the upgrade.2. If you have any vendor databases, make sure that they have certified their products for the newer version of SQL Server. |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-15 : 23:10:15
|
| Thanks James, Right now we are taking back up and in process to restore to make sure it.We are also talking with Vendor and other 3rd party software company that they e supporting newer version.Could you please let me know that Server virtualization is good or stand alone server hardware is good? and also 8 core/CPU is enough?Thanks and appreciate your response! |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-17 : 17:36:19
|
| Please let m know as we are planning to upgrade sql 2008 and need to decide which one is optimum and how many processor will be enough?Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-07-17 : 20:00:48
|
| We can't answer how many processors you'll need. Every environment has its own needs.Virtualization is okay in lots of cases. Standalone server or clusters are good in other cases. You really need to tell us more about the application and database for us to help. The vendor/3rd party software company should be able to help you with some of this as they should have minimum hardware specs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-18 : 14:09:04
|
| Thanks Tara.We have almost 15 DB, one of the replication DB is big - 280 GB, others are small ranging from 10 to 25 GB, currently we ae running sql 2005 standard edition on windows 2003, 4 CPU, 4 GB Memory (too low).We are thinking to upgrade sql 2008R2 - enterprise edition but still not sure what should be the ideal CPU - processor, MEM configuration and Virtualization v/s physical server option will be benefitial?Thanks for your feedback? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-19 : 08:21:04
|
| Not much, sometimes I see Parallelism and memory issue but not that big as I am confused exactly what I should for bottleneck. Buffer Cache Hit Ratio is 99% all the time, CPU mostly under 70%. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Sql server upgrade fro m2003 to 2008