Re: SQL Server 2005 Cluster Setup Quiz

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: 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: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I used Registry Editor to delete PendingFileRenameOperations in the ... I restarted the Server and tried to install SQL ... Press Retry to continue installation or Cancel to exit setup. ...
    (microsoft.public.windows.server.sbs)