"JBailey" <abc@123.com> wrote in message
news:%23i$buE9nDHA.3256@tk2msftngp13.phx.gbl...
> I have a 2 node cluster with 3 instances of SQL. One specific instance,
when
> I attemtp to take it offline produces the following error:
>
> In cluster administrator is shows the SQL Server Resource as Failed
>
> Event Viewer produces the following:
>
> Source:ClusSvc
> Event ID: 1117
> Description: Cluster resouce SQL Server(InstanceName) failed to come
offline
>
> The SQL service for this instance does stop, and the resource also has no
> problems coming back online.
> This SQL instance also is non-production, and hasnt had much traffic at
all
>
> Any ideas why this is happening?
>
> Thanks,
> JBailey
>
>

"BB" <bbychkov@hotmail.com> wrote in message
news:%23heN0b9nDHA.360@TK2MSFTNGP12.phx.gbl...
> I have the similar situation on cluster with 8GB of RAM per server.
> 2 instances, each is configured to use 3.5 GB (/PAE, /3GB, AWE enabled).
> There are ~350 databases on each instance.
> When I take an instance offline it gives me same message.
>
> I believe it's related to the Pending Timeout interval set in the cluster
> admin. My understanding is that it just takes longer for SQL to shutdown
> than the cluster is willing to wait for it... One time I detached most of
> the databases and then the problem disappeared. It returned when I
> re-attached the DBs back. Unfortunately, it's a production environment, I
> can't play much with it. :-(
>
> B.
>
> "JBailey" <abc@123.com> wrote in message
> news:%23i$buE9nDHA.3256@tk2msftngp13.phx.gbl...
> > I have a 2 node cluster with 3 instances of SQL. One specific instance,
> when
> > I attemtp to take it offline produces the following error:
> >
> > In cluster administrator is shows the SQL Server Resource as Failed
> >
> > Event Viewer produces the following:
> >
> > Source:ClusSvc
> > Event ID: 1117
> > Description: Cluster resouce SQL Server(InstanceName) failed to come
> offline
> >
> > The SQL service for this instance does stop, and the resource also has
no
> > problems coming back online.
> > This SQL instance also is non-production, and hasnt had much traffic at
> all
> >
> > Any ideas why this is happening?
> >
> > Thanks,
> > JBailey
> >
> >
>
>