Re: SQL Server 2005 Cluster Setup Quiz

I did test and it did not install the client tools. I did fail to read the
release notes :)

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:OSZKgl4RGHA.5644@xxxxxxxxxxxxxxxxxxxxxxx
Setup is supposed to install client tools on all nodes. A bug in the
install routine prevents that. You have to read the release notes or
actually do the install to catch that one.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:OzxOv7uRGHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
Cool. I got another one right. I think I may have passed! Sweet!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:uegnVmtRGHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
Correction. #8 should be D.

"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:emP0yprRGHA.5468@xxxxxxxxxxxxxxxxxxxxxxx
Lets give this a try.

Answers Inline

"Ray Schueler[MSFT]" <RaySchuelerMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:411EC245-ED72-4F49-A21E-A6E58416A909@xxxxxxxxxxxxxxxx
This quiz consists of 10 multiple choice questions and 1 extra credit
question. This is an "open book" quiz. Feel free to use any resources
at your
disposal.

Feedback is welcome.
Ray

This posting is provided "AS IS" with no warranties, and confers no
rights.
------------------------------------------------------------------------------
1. Where is sqlserver.exe located for the named instance "STPNAMED"?
This is
the first instance on the cluster. (Assume the default directory is
used.)

a) ..\Microsoft SQL Server\MSSQL$STPNAMED\Binn\sqlservr.exe
b) ..\Microsoft SQL Server\MSSQL.1\Binn\sqlservr.exe
c) ..\Microsoft SQL Server\MSSQL$STPNAMED\MSSQL\Binn\sqlservr.exe
d) ..\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

B.
2. How many cluster nodes does SQL Server 2005 Enterprise Edition
support on
x86, x64 and IA64 platforms?

a) Infinite
b) 8 nodes
c) 4 nodes
d) 2 nodes

B.
3. Where are the SQL Server 2005 setup log files found?

a) "\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG"
b) %temp%
c) ''\Program Files\Microsoft SQL Server\90\Shared"
d) %windir%

D.
4. What is the template.ini used for?

a) Diagnosing setup failures
b) Provide a template for unattended setup command lines.
c) Provide a template on how to read SQL Server 2005 setup log files.
d) Provide a template for writing stored procedures.

B.
5. When installing a SQL Server 2005 failover cluster, what service
runs
setup on remote nodes?

a) Task Scheduler service
b) SQLSETUP service
c) Cryptographic service
d) SQL service

A. -- Same as for SQL 2000 SP4 and later hotfixes.
6. How do you change the IP address of the SQL IP cluster resource
after a
SQL Server 2005 failover cluster has been installed?

a) Run setup.exe from CD, select maintenance, select change IP.
b) Click on the SQL Server 2005 entry in Add/Remove Programs, select
maintenance, select change IP.
c) Uninstall SQL Server 2005 cluster, Reinstall with new IP address.
d) Change the IP in cluster administrator.

D. --And you don't have to hack the registry anymore.

7. What is different about the remote setup dialog in SQL Server 2005
compared to SQL Server 2000?
Reminder: This is an "open book" quiz.

a) A login and password need to be entered for each node.
b) The remote setup dialog has been removed.
c) There is no change in the dialog.
d) Only the password of the logged-on account can be entered.

B. -- And it's about time.

8. You select all components on the component selection dialog,
including
SQL Server and Analysis Services to be installed as a failover
cluster. On
your 2 node cluster, what components will be installed on both nodes?

a) Management Tools
b) All components
c) SQL Server Engine and Management Tools
d) SQL Server Engine and Analysis Services

B.
9. What are 5 cluster specific command line options for unattended
cluster
setup?

a) VS, INSTALLVS, IP, GROUP, ADDNODE
b) VS, INSTALLSQLDIR, TARGETCOMPUTER, ADDLOCAL, SAPWD
c) INSTANCENAME, IP, GROUP, CLUSTER, TARGETCOMPUTER
d) INSTANCENAME, ADMINACCOUNT, ADMINPASSWORD, IP, GROUP

A.
10. How have the permissions changed on files and folders on the
shared
drive of a SQL Server 2005 failover cluster installation?

a) SQL service accounts are given access to files and folders.
b) Local groups are given access to files and folders.
c) Local administrator access is removed from files and folders.
d) Domain groups are given access to files and folders.

A

11. Extra Credit:

Installation Order:
Instance 1 - Standalone default instance installed on node 1
Instance 2 - SQL Engine failover cluster named instance installed on
nodes 1
and 2.
Instance 3 - Standalone named instance installed on node 2.

Where will sqlservr.exe be found in the default location of the 3rd
instance
on node 1?

a) ..\Microsoft SQL Server\MSSQL.1\Binn\sqlservr.exe
b) ..\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe
c) ..\Microsoft SQL Server\MSSQL.2\Binn\sqlservr.exe
d) ..\Microsoft SQL Server\MSSQL.3\MSSQL\Binn\sqlservr.exe

A. But I am guessing here.










.

Relevant Pages

  • Re: Setup cluster SQL server in SAN due to task scheduler
    ... Dell PV220S (Cluster Mode, PERC 3/DC) ... SQL Database Engine ... Microsoft SQL Server 2005 Setup ... To install all SQL Server features, install IIS from Add or Remove Programs ...
    (microsoft.public.sqlserver.clustering)
  • RE: Clustering Question
    ... if you want to install SQL cluster on both node at the same time. ... you could also install it on one node and then add another node. ... Microsoft SQL Server 2000, if Microsoft SQL Server 2000 is clustered. ...
    (microsoft.public.sqlserver.setup)
  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: W2K SQL Cluster MSDTC cannot failover
    ... and installed SQL for him. ... SQL agent during the comclust.exe install or it will just hang. ... > Server Agent, SQL Server Fulltext; ... When I try to failover SQL Cluster from Node A to Node ...
    (microsoft.public.sqlserver.clustering)