"Woo" <Woo@discussions.microsoft.com> wrote in message
news:EFEB3B7C-B702-49AB-AE4A-D94337B9A9BB@microsoft.com...
> Hiya,
>
> We have several servers that have SQL Server and an application installed,
> therefore they are not just dedicated to SQL. Some of these applications
> have services, other have exe's that are launched by users over the
network.
>
> We are looking at high availability options for these servers, to ensure
> that should the server go down we can recover both the SQL databases and
the
> application installation as quick as possible.
>
> Ideally we would want a clustering solution. Does anyone know If
clustering
> could work with such a set up?
>
> Or would SQL2005 mirroring work?
>
> Ta
> Wendy

"Woo" <Woo@discussions.microsoft.com> wrote in message
news:C0ECD89D-3FB9-4045-90DF-B5D74EF4DE65@microsoft.com...
> Does this setup have to be active/active? We were wanting to use
> active/passive set up.
>
>
> thanks
> wendy
>
>
>
>
> "Edwin vMierlo" wrote:
>
> > Wendy,
> >
> > SQL server can be clustered for HA, so there is no problem there.
> >
> > In regards to "an application" then the question is : what application ?
> > - if this is a commercial package, then I would recommend asking the
vendor
> > if this application is cluster aware and can be run in a cluster (and I
> > would ask the vendor detailed instructions and best practices for this)
> > - if this is home grown application, I would go back to the application
> > devellopers and ask them to make the application cluster aware. Please
> > reference the Cluster API as a reference
> > http://msdn2.microsoft.com/en-us/library/aa372250.aspx.
> >
> > Once your application can be clustered, you can run a two node cluster,
one
> > SQL group/instance on alive on 1 node, the other node would run your
> > application. In case of a failure, the surviving node would run both
your
> > SQL as well as your application.
> >
> > HTH,
> > _Edwin.
> >
> >
> >
> > "Woo" <Woo@discussions.microsoft.com> wrote in message
> > news:EFEB3B7C-B702-49AB-AE4A-D94337B9A9BB@microsoft.com...
> > > Hiya,
> > >
> > > We have several servers that have SQL Server and an application
installed,
> > > therefore they are not just dedicated to SQL. Some of these
applications
> > > have services, other have exe's that are launched by users over the
> > network.
> > >
> > > We are looking at high availability options for these servers, to
ensure
> > > that should the server go down we can recover both the SQL databases
and
> > the
> > > application installation as quick as possible.
> > >
> > > Ideally we would want a clustering solution. Does anyone know If
> > clustering
> > > could work with such a set up?
> > >
> > > Or would SQL2005 mirroring work?
> > >
> > > Ta
> > > Wendy
> >
> >
> >

"Edwin vMierlo" wrote:

> Wendy,
>
> SQL server can be clustered for HA, so there is no problem there.
>
> In regards to "an application" then the question is : what application ?
> - if this is a commercial package, then I would recommend asking the vendor
> if this application is cluster aware and can be run in a cluster (and I
> would ask the vendor detailed instructions and best practices for this)
> - if this is home grown application, I would go back to the application
> devellopers and ask them to make the application cluster aware. Please
> reference the Cluster API as a reference
> http://msdn2.microsoft.com/en-us/library/aa372250.aspx.
>
> Once your application can be clustered, you can run a two node cluster, one
> SQL group/instance on alive on 1 node, the other node would run your
> application. In case of a failure, the surviving node would run both your
> SQL as well as your application.
>
> HTH,
> _Edwin.
>
>
>
> "Woo" <Woo@discussions.microsoft.com> wrote in message
> news:EFEB3B7C-B702-49AB-AE4A-D94337B9A9BB@microsoft.com...
> > Hiya,
> >
> > We have several servers that have SQL Server and an application installed,
> > therefore they are not just dedicated to SQL. Some of these applications
> > have services, other have exe's that are launched by users over the
> network.
> >
> > We are looking at high availability options for these servers, to ensure
> > that should the server go down we can recover both the SQL databases and
> the
> > application installation as quick as possible.
> >
> > Ideally we would want a clustering solution. Does anyone know If
> clustering
> > could work with such a set up?
> >
> > Or would SQL2005 mirroring work?
> >
> > Ta
> > Wendy
>
>