Re: Creating Database (Urgently need help)

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/19/04 

Date: Thu, 18 Mar 2004 23:19:48 -0500

Select the SQL Server group.
Right click in the SLQ SErver (Instancename) resource, select properties.
Select the dependancies tab.
All physical disks and the Network Name resource should be in the list. Any
physical disk NOT in the list cannot be used for SQL data storage. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@discussions.microsoft.com> wrote in message
news:1018d01c40d53$c47783b0$a101280a@phx.gbl...
> There's 2 Groups:
> 1. Cluter Group
>    - Cluster IP Address
>    - Cluster Name
>    - MSDTC
>    - Quorum Disk
>
> 2. Share Disk
>    - All Disk Resources
>    - All SQL Server Service
>
> and configured SQL Server startup dependencies after all
> disk resources
>
>
>
>
>
>
> >-----Original Message-----
> >Is the shared disk a clustered resource that is part of
> the SQL group and is
> >the SQL server service dependant on that physical disk
> resource.  Unless the
> >answer is YES to all of these questions, then clustered
> SQL cannot put data
> >on that disk.
> >
> >-- 
> >Geoff N. Hiten
> >Microsoft SQL Server MVP
> >Senior Database Administrator
> >Careerbuilder.com
> >
> >I support the Professional Association for SQL Server
> >www.sqlpass.org
> >
> >"Yen" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:f98d01c40d0d$d51dc350$a501280a@phx.gbl...
> >> Installed SQL 2000 Enterprise with SP3 running on
> windows
> >> 2003 enterprise server, when creating database at share
> >> disk, got 5105 Error.  try add access right for service
> >> account to share disk still failure.  Please help
> >
> >
> >.
> >

Relevant Pages

  • Re: Help installing SQL2000 on Win2003 - MSDTC resources required?
    ... MSDTC resource but you need another physical disk and network name so I ... network name as these resources and in the same group as the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • RE: Failed resources
    ... catastrophic result, when I just move one resource to another node, like the ... > Node A hosts normally SQL Server 2K and File System ... > Cluster resource 'Disk Z:' in Resource Group 'Cluster Group' failed. ... > Cluster resource 'Disk V:' in Resource Group 'SQL Server Group' failed. ...
    (microsoft.public.windows.server.clustering)
  • Re: Server stops responding
    ... you may want to track your database with SQL Server Profiler to see if some processes takes longer then they should take. ... Physical Disk: % Disk Time (seperately for your OS and database disks, ...
    (microsoft.public.sqlserver.clients)
  • Re: Determine Disk Block Size ?
    ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
    (microsoft.public.sqlserver.server)
  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... Bring both resource groups to the node you are logged into. ... I support the Professional Association for SQL Server ... >>> physical disk owened by the first node, ... >>> offline with cluster administrator) WHich is better? ...
    (microsoft.public.sqlserver.clustering)
Loading