SAN and SQL

Hi All
We are trying to consolidate all the SQL servers (more then 250 instances).
We are considering Multi instance Sql Cluster on SAN
Is there a document/weblink that expalins the SAN systems , and
Installation/Setup of SQL Cluster on SAN.
Pro's and Con's
thanks in advance
You may find the following links helpful
Server Consolidation
====================
Planning for Consolidation with SQL Server 2000 </technet/prodtechnol/sql/2000/plan/sql2kcon.mspx>
SQL Server Consolidation on the 64-bit Platform </technet/prodtechnol/sql/2000/deploy/64bitconsolidation.mspx>
SQL Server Consolidation on the 32-bit Platform Using a Clustered Environment </technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx>
Microsoft SQL Server 2000 Scalability ProjectServer Consolidation <http://msdn.microsoft.com/library/de...asphosting.asp>
Additional Resources
===================
http://www.microsoft.com/sql/techinf...alability.mspx
http://www.microsoft.com/sql/techinf...ilability.mspx
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Nik
Here is another helpful link:
http://www.sql-server-performance.co...stall_main.asp
Regards
cT
"Nik" wrote:

> Hi All
> We are trying to consolidate all the SQL servers (more then 250 instances).
> We are considering Multi instance Sql Cluster on SAN
> Is there a document/weblink that expalins the SAN systems , and
> Installation/Setup of SQL Cluster on SAN.
> Pro's and Con's
> thanks in advance
>
>
|||thanks guys for prompt reply
Any info on SAN would be really helpful.
Like basics of SAN, Configuration parameters, Considerations of SQL on SAN
etc
"Charles Tolento" <CharlesTolento@.discussions.microsoft.com> wrote in
message news:DD97144D-BC43-493F-B2BD-E159AFE18829@.microsoft.com...
> Nik
> Here is another helpful link:
>
http://www.sql-server-performance.co...stall_main.asp[vbcol=seagreen]
> Regards
> cT
> "Nik" wrote:
instances).[vbcol=seagreen]

Sample databases.

I'm in the process of running a set of tests on SQL Server 2005 (multiple
instances).
For the scenarios that I want to test â' require 4-5 sample databases (in
addition to the AdventureWorks provided by Microsoft). Can someone point me
to a location from where I can download sample databases? The databases have
to be different from one another - schema, data, usage, etc.. Once Iâ'm
through with the testing will drop the databases.
Cheers!
SQLCatzHi
1)
You can BACKUP/RESTORE or attach/detach these databases from SQL Server
2000 to SQL Server 2005
2)
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:71DAB7C0-608F-4FFC-B695-F8810E15BCE4@.microsoft.com...
> I'm in the process of running a set of tests on SQL Server 2005 (multiple
> instances).
> For the scenarios that I want to test ? require 4-5 sample databases (in
> addition to the AdventureWorks provided by Microsoft). Can someone point
> me
> to a location from where I can download sample databases? The databases
> have
> to be different from one another - schema, data, usage, etc.. Once I?m
> through with the testing will drop the databases.
> Cheers!
> SQLCatz
>|||Hi
I am not sure why you need the database to be different?
Pubs and Northwind can be downloaded from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
You should have both Adventureworks and AdventureworksDW!
For a fifth I would have throught you would have one of your own?
John
"SQLCatz" wrote:
> I'm in the process of running a set of tests on SQL Server 2005 (multiple
> instances).
> For the scenarios that I want to test â' require 4-5 sample databases (in
> addition to the AdventureWorks provided by Microsoft). Can someone point me
> to a location from where I can download sample databases? The databases have
> to be different from one another - schema, data, usage, etc.. Once Iâ'm
> through with the testing will drop the databases.
> Cheers!
> SQLCatz
>