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 on Same Box (for educational/training purposes)

Is it possible to setup a second instance of SQL Server Enterprise on a box
and setup clustering? I have someone asking me that has only one Server to
do this with and they want to learn about Clustering.
Win2003 <-> Win2003 (SameBox)
OR
Can you run SQL Server on an XP machine and still setup clustering on a
Win2K03 Server and cluster the 2?
XP <--> Win2003 (Two Boxes)
Thanks
Erik
Cluster on XP <--> Win2003 (Two Boxes) -- No, the hardware needs to be
identical.
A better solution would be to run PC emulation software like VMWARE and
create a 2-node virtual cluster on one Windows 2003 computer.
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.

Clone SQL DB (using VB?)

Hi all,
I'm having a SQL Server database called X. For testing and training, I
would like to make a copy of the entire DB to Y. This copy should
include all data, properties, indexes, views, etc. Unfortunately, all
my attempts to automate this failed...
Server = MSDE2a
Original database is a database marked for replication so I can't make
an easy copy...
App = VB6
- SQL job: fails on certain tables due to large 'memo' fields (ntext >
10Mb).
- DAO: trying to copy the tables from dbX to dbY fails while
getting/setting properties. Even when getting the fields (for each
srcField in srcTable.Fields; set destField = srcField) gives errors...
- ADOX: Haven't been able to get all the properties and indexes across.
ADOX doesn't seem to have all methods available to accomplish that.
Current idea is to take a script from the DB, adjust the paths and
names and use that to generate the DB. Afterwards, loop through all
tables and copy the contents from dbX to dbY.
While I haven't looked into it, I might run into a problem because
probably not all tools are installed on the application PC and without
them so I can't run SQL scripts from the command line... Not sure if I
can distribute all tools (MSDE) to make that working.
Another thing might be that I need to find out what the relative path
is to the server in order to create the files at the correct locations.
They are different because the app is on PC1 and the SQLserver is on
PC2. So I need to update the script (that wouldn't be the big problem)
but I'm not sure on how this would be interpreted in the above
scenario...
Is this the correct way to copy a DB including indexes and properties
(like default values, etc.)? Or is there something easier?
Many thanks,
GB
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Couldn't you simply backup the database on the source server and the copy
the backup file to a share on the destination server and do a restore?'
Jim
"Gijs Beukenoot" <Gijs.DOT.Beukenoot@.AT@.Wanadoo.DOT.nl> wrote in message
news:mn.ba4e7d52bd68e489.23024@.Wanadoo.DOT.nl...
> Hi all,
> I'm having a SQL Server database called X. For testing and training, I
> would like to make a copy of the entire DB to Y. This copy should include
> all data, properties, indexes, views, etc. Unfortunately, all my attempts
> to automate this failed...
> Server = MSDE2a
> Original database is a database marked for replication so I can't make an
> easy copy...
> App = VB6
> - SQL job: fails on certain tables due to large 'memo' fields (ntext >
> 10Mb).
> - DAO: trying to copy the tables from dbX to dbY fails while
> getting/setting properties. Even when getting the fields (for each
> srcField in srcTable.Fields; set destField = srcField) gives errors...
> - ADOX: Haven't been able to get all the properties and indexes across.
> ADOX doesn't seem to have all methods available to accomplish that.
> Current idea is to take a script from the DB, adjust the paths and names
> and use that to generate the DB. Afterwards, loop through all tables and
> copy the contents from dbX to dbY.
> While I haven't looked into it, I might run into a problem because
> probably not all tools are installed on the application PC and without
> them so I can't run SQL scripts from the command line... Not sure if I can
> distribute all tools (MSDE) to make that working.
> Another thing might be that I need to find out what the relative path is
> to the server in order to create the files at the correct locations. They
> are different because the app is on PC1 and the SQLserver is on PC2. So I
> need to update the script (that wouldn't be the big problem) but I'm not
> sure on how this would be interpreted in the above scenario...
> Is this the correct way to copy a DB including indexes and properties
> (like default values, etc.)? Or is there something easier?
> Many thanks,
> GB
> --
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice how
> restful it is to watch the cursor blink. Close your eyes. The opinions
> stated above are yours. When I snap my fingers, you cannot imagine why you
> ever felt otherwise. <snap>
>
|||Jim Young drukte met precisie uit :
> Couldn't you simply backup the database on the source server and the copy the
> backup file to a share on the destination server and do a restore?'
> Jim
>
<<cut>>
Jim,
Both databases are on the same machine so that makes it a little easier
to do that. And, I've done that a few times (using Enterprise Manager
from another machine). The only problems I saw then is in the (odd)
naming of the databasefiles. I can't remember exactly, but I remember
the filenames where correct (dbY) but in some of the properties, the
internal name was still <path>\dbX. I'll admit, so far, this seems to
be the easiest way to accomplish all this. If I code it, the users
shouldn't be able to mess things up (like using EM to do this; it
really makes you read everything twice before you restore it the wrong
way...)
I'll guess I'll hop along that path then, thanks
GB
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>