Solved

SQL Server

Posted on 2013-01-08
8
191 Views
Last Modified: 2013-01-11
Does anyone have any suggestions on how to combine 20 SQL servers that is mix of SQL 2000 and SQL 2008. Basically there is a migration plan to move them to a new domain and I'm a little puzzled as to 20 SQL servers..
I guess perhaps a Cluseter would work out? Any suggestions on how to even go about planning this?
0
Comment
Question by:shoris
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 15

Expert Comment

by:Anuj
Comment Utility
Are you trying to do a consolidation?
0
 

Author Comment

by:shoris
Comment Utility
Yes I am..
0
 
LVL 9

Accepted Solution

by:
MattSQL earned 250 total points
Comment Utility
There's no real issue with running SQL versions side by side:

http://msdn.microsoft.com/en-us/library/ms143694(v=sql.100).aspx

More important considerations/discussions to have around consolidation would be around how do you want to group your SQL instances? What makes sense for your environment?

Group by business criticality? Put crucial components together onto somehting like a cluster for high availability?

Group by workload? Separate highly active SQL Servers onto dedicate hardware. Group less active systems together on the same SQL instance, or different SQL instances on the same machine?

Group by security requirements? Group databases and applications by what user access, level of security and auditing requirements are appropriate for the business group?

Physical or Virtual?

That's probably more questions than answers :) but these are the discussions to be had...
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 250 total points
Comment Utility
First you have to decide how many new instances you want.

Do you want everything to go into 1 new instance? 2? Other number?

If more than 1, decide on the SQL version for each instance.

Decide on the amount of RAM to be retained out of all SQLs, then the amount of RAM to give each SQL instance.

Before moving SQL 2000 dbs to a higher instance, MS provides a free program that can point out any issues you'll have from obsolete things in SQL 2000.  Query issues are minor and easy to fix.

The monster issue is you have SQL 2000 dts packages.  Converting them is usually a royal pita, unless you have an SSIS jock available to do it.

You also have to check for linked servers, external directory permissions, other permissions, etc..
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:shoris
Comment Utility
I really appreciate all the feedback this is great information. Can you please inform me where i can get this free tool from Microsoft? Also, is there one for higher versions to run?

Any additional information and what to look ask and look for would be amazing. Perhaps creating the checklist and critical applications is a definite i can see.
0
 
LVL 9

Expert Comment

by:MattSQL
Comment Utility
This might be the upgrade advisor which is available in the planning tab of the SQL Server setup wizard. This is if you are planning on upgrading your SQL2000 instances to SQL2008.

Check out this whitepaper.

http://download.microsoft.com/download/2/0/B/20B90384-F3FE-4331-AA12-FD58E6AB66C2/SQL%20Server%202000%20to%202008%20Upgrade%20White%20Paper.docx
0
 

Author Comment

by:shoris
Comment Utility
Is there any tool that will do an advisory to move into a SQL Cluster by any chance that you know of?
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
The base tool is "SQL Upgrade Advisor".  There are separate Upgrade Advisors for each version of SQL.

I strongly suggest taking all your current SQL 2000 to SQL 2008 and not some intermediate SQL 2005 step or leaving them at SQL 2000.  After all, SQL 2012 is already out.  You don't want to get further behind.

Nothing special for a cluster.  SQL db itself is unconcerned with cluster or not.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now