Cluster training

Does anyone have suggestions for courses (offsite or CBT) to help my team come up to speed on clusters? My team members are DBAs.
Check out: www.solidqualitylearning.com
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Brenda Pingle" <Brenda Pingle@.discussions.microsoft.com> wrote in message
news:616748DE-D8DF-497F-8E9B-9B660CB0D786@.microsoft.com...
Does anyone have suggestions for courses (offsite or CBT) to help my team
come up to speed on clusters? My team members are DBAs.
|||Here is a link to Windows Clustering exam.
Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
http://www.microsoft.com/learning/exams/70-223.asp
Implementing Microsoft Windows 2000 Clustering
Course 2087: Three days; Instructor-led
http://www.microsoft.com/traincert/s...2087aFINAL.ASP
I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Microsoft Knowledge Base Articles
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
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
|||im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:

> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
> http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
> http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
> http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
> http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?kbid=260758
> 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
>
>
|||You can emulate clustering through VMWare.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Benjsoft" <Benjsoft@.discussions.microsoft.com> wrote in message
news:0E6D46CF-6410-4154-9EF0-FBDC1A9CAE54@.microsoft.com...
im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:

> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft
Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the
following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
>
http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
>
http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
>
http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and
Service Pack
http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
>
http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for
Failover Clustering
>
http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
> http://support.microsoft.com/?kbid=260758
> 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
>
>

Cluster or Mirror

Hi,
I'm currently looking in the possiblities for a SQL server install. The web
project needs a SQL database with a high availability. Speed and size are not
that important as the load will be medium (especially for the new enterprise
class servers), but it cannot eb offline for more then minutes. Assuming
there is suffient budget what option would be preferred:
HP DL380 cluster with SAN : diskset in SAN RAID 1+0 with SQL enterprise and
SQL virtual server setup
OR
2x Fully redundent HP DL380's with own diskset (RAID 1+0), one active SQL
Std, and one passive. Replication using DoubleTake or Neverfail alikes.
The fail-switch should also be automatic and should react within max 5
minutes.
Any idea's pro + cons?
Thanks
Have you looked at Log Shipping as an alternative?
Regards
Darryl Pollock
Squirrel Consulting
www.remotesquirrel.com - Performance Monitoring - Anytime ! Anywhere!
"christophe" <christophe@.discussions.microsoft.com> wrote in message
news:250E4D88-6464-4E88-80AA-E0D8262B4CD1@.microsoft.com...
> Hi,
> I'm currently looking in the possiblities for a SQL server install. The
> web
> project needs a SQL database with a high availability. Speed and size are
> not
> that important as the load will be medium (especially for the new
> enterprise
> class servers), but it cannot eb offline for more then minutes. Assuming
> there is suffient budget what option would be preferred:
> HP DL380 cluster with SAN : diskset in SAN RAID 1+0 with SQL enterprise
> and
> SQL virtual server setup
> OR
> 2x Fully redundent HP DL380's with own diskset (RAID 1+0), one active SQL
> Std, and one passive. Replication using DoubleTake or Neverfail alikes.
> The fail-switch should also be automatic and should react within max 5
> minutes.
> Any idea's pro + cons?
> Thanks
|||yes, but the data can only be out of sync for max a few minutes and from what
I read replication is faster for something like that. I also need an
automated switch to the standby server in case of a failure of the primary
server. The application only knows 1 SQL server connection.
"Darryl Pollock" wrote:

> Have you looked at Log Shipping as an alternative?
> Regards
> Darryl Pollock
> Squirrel Consulting
> www.remotesquirrel.com - Performance Monitoring - Anytime ! Anywhere!
>
> "christophe" <christophe@.discussions.microsoft.com> wrote in message
> news:250E4D88-6464-4E88-80AA-E0D8262B4CD1@.microsoft.com...
>
>
|||Hi
Just remember, Cluster or disk/volume replication level does not protect you
against database/disk corruption. The corruption is faithfully propogated to
the other drives in the case of replication and is on the single copy on the
SAN.
For SQL 2000, Microsoft Windows Clustering is the way for the least downtime
and no human intervention is required. Clusters typically fail over in <20
seconds, depending on how many transactions need to rolled forward/back.
Regards
Mike
"christophe" wrote:
[vbcol=seagreen]
> yes, but the data can only be out of sync for max a few minutes and from what
> I read replication is faster for something like that. I also need an
> automated switch to the standby server in case of a failure of the primary
> server. The application only knows 1 SQL server connection.
> "Darryl Pollock" wrote:
|||I would argue that the time required to failover is a function of how long
it takes for the transaction log to be applied from the failed node to the
failed over node.
For most production systems with VLDBs you should be dumping the log very
frequently, ie under 5 minutes.
While 20 s is an often quoted statistic, I think 1 - 2 minutes might be more
realistic.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:0B6AD0FE-AFC4-46F3-AAAD-031C1F179600@.microsoft.com...
> Hi
> Just remember, Cluster or disk/volume replication level does not protect
you
> against database/disk corruption. The corruption is faithfully propogated
to
> the other drives in the case of replication and is on the single copy on
the
> SAN.
> For SQL 2000, Microsoft Windows Clustering is the way for the least
downtime[vbcol=seagreen]
> and no human intervention is required. Clusters typically fail over in <20
> seconds, depending on how many transactions need to rolled forward/back.
> Regards
> Mike
> "christophe" wrote:
what[vbcol=seagreen]
primary[vbcol=seagreen]
The[vbcol=seagreen]
size are[vbcol=seagreen]
Assuming[vbcol=seagreen]
enterprise[vbcol=seagreen]
active SQL[vbcol=seagreen]
alikes.[vbcol=seagreen]
5[vbcol=seagreen]

Close Enough?

I'm a VB6 / MS Access programmer trying to get up to speed in the world of
ASP.NET and SQL Server 2000. I'm on a fairly large web database project so
I'm trying to use VisualUML for management of the database schema. I expect
many generations of design as the requirements become defined in an iterate
process. Therefore a DB design tools like VisualUML is highly desirable.
When I worked through the WebMatrix tutorials I built a table in SQL Server
Enterprise Manager whose Create SQL looks like this (generated from SQL
Query Analyzer):
CREATE TABLE [wmt_Orders] (
[OrderID] [int] IDENTITY (1, 1) NOT NULL ,
[OrderDate] [datetime] NOT NULL ,
[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS N
OT NULL
,
CONSTRAINT [PK_wmt_Orders] PRIMARY KEY CLUSTERED
(
[OrderID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
I've been trying to use VisualUML to create the *same* *exact* thing.
Here's my first "maybe" try (from SQL Query Analyzer):
CREATE TABLE [wmt_Orders_2] (
[OrderID] [int] NOT NULL ,
[OrderDate] [datetime] NOT NULL ,
[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS N
OT NULL
,
PRIMARY KEY CLUSTERED
(
[OrderID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
I noticed the lack of the CONSTRAINT on the primary key. Here are two more
tries, setting various attributes in VisualUML.
CREATE TABLE [wmt_Orders_3] (
[OrderID] [int] IDENTITY (100, 1) NOT NULL ,
[OrderDate] [datetime] NOT NULL ,
[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS N
OT NULL
,
PRIMARY KEY CLUSTERED
(
[OrderID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [wmt_Orders_4] (
[OrderID] [int] IDENTITY (100, 1) NOT NULL ,
[OrderDate] [datetime] NOT NULL ,
[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS N
OT NULL
,
PRIMARY KEY CLUSTERED
(
[OrderID]
) ON [PRIMARY] ,
UNIQUE NONCLUSTERED
(
[OrderID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
I haven't been able to figure out how to make VisualUML create a table whose
CREATE SQL is identical to that created "by hand." Are any of these "close
enough" to be completely useful? (If so I hope it's wmt_Orders_2 ! <g> )
The project I'm working on has scores of tables and quite a few 0-M:0M
(zero-Many:zero-Many) relationships so I really want to avoid future
problems caused by current ignorance. ;-)
Thanks, & please go easy on the SQL Server 2000 newbie! <g>
-- MarkHi Mark,
I learned you want to use VisualUML to create table DDL as below:
CREATE TABLE [wmt_Orders] (
[OrderID] [int] IDENTITY (1, 1) NOT NULL ,
[OrderDate] [datetime] NOT NULL ,
[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS N
OT NULL
,
CONSTRAINT [PK_wmt_Orders] PRIMARY KEY CLUSTERED
(
[OrderID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
For this VisualUML question, you can post it into the VisualUML forum for
further support.
http://www.visualobject.com/forums/
http://www.visualuml.com/default.htm
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.