Disaster Recovery

I am planing to implement a disaster recovery site for my enterprise system
consisting of database servers( sql server 2000) , web servers(IIS) and
application servers, all on microsoft platforms.
in case of any disaster it should failover to the other server in other site.
what about using third party solution like Neverfail or Xosoft ,Vertas
solution for achieving this.
which you recommend ?
Pls SHARE your opinion.
Note:cost is not a constarint.Take a look at
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>I am planing to implement a disaster recovery site for my enterprise system
> consisting of database servers( sql server 2000) , web servers(IIS) and
> application servers, all on microsoft platforms.
> in case of any disaster it should failover to the other server in other
> site.
> what about using third party solution like Neverfail or Xosoft ,Vertas
> solution for achieving this.
> which you recommend ?
> Pls SHARE your opinion.
> Note:cost is not a constarint.
>|||Hi uri,
I am already having cluster,log sipping, replication configured for database
but what i am looking for is a automatic failover to different site without
any data loss.
"Uri Dimant" wrote:
> Take a look at
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> >I am planing to implement a disaster recovery site for my enterprise system
> > consisting of database servers( sql server 2000) , web servers(IIS) and
> > application servers, all on microsoft platforms.
> > in case of any disaster it should failover to the other server in other
> > site.
> > what about using third party solution like Neverfail or Xosoft ,Vertas
> > solution for achieving this.
> >
> > which you recommend ?
> >
> > Pls SHARE your opinion.
> >
> > Note:cost is not a constarint.
> >
>
>|||If your requirements are automatic failover without data loss then ...
I understand that only Failover Clustering and Database Mirroring provide
automatic failover with no data loss. But failover clustering has only one
copy of the database. So, for your requirements that leaves database
mirroring as your only choice.
But here I am talking only about SQL Server technologies. I do not know
about choices from other vendors.
Benjamin Nevarez, MCDBA, OCP
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> Hi uri,
> I am already having cluster,log sipping, replication configured for
> database
> but what i am looking for is a automatic failover to different site
> without
> any data loss.
> "Uri Dimant" wrote:
>> Take a look at
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>>
>>
>> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
>> in
>> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>> >I am planing to implement a disaster recovery site for my enterprise
>> >system
>> > consisting of database servers( sql server 2000) , web servers(IIS) and
>> > application servers, all on microsoft platforms.
>> > in case of any disaster it should failover to the other server in other
>> > site.
>> > what about using third party solution like Neverfail or Xosoft ,Vertas
>> > solution for achieving this.
>> >
>> > which you recommend ?
>> >
>> > Pls SHARE your opinion.
>> >
>> > Note:cost is not a constarint.
>> >
>>|||Ben
Database Mirroring will be available for production only in the first half
2006.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> If your requirements are automatic failover without data loss then ...
> I understand that only Failover Clustering and Database Mirroring provide
> automatic failover with no data loss. But failover clustering has only one
> copy of the database. So, for your requirements that leaves database
> mirroring as your only choice.
> But here I am talking only about SQL Server technologies. I do not know
> about choices from other vendors.
> Benjamin Nevarez, MCDBA, OCP
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
>> Hi uri,
>> I am already having cluster,log sipping, replication configured for
>> database
>> but what i am looking for is a automatic failover to different site
>> without
>> any data loss.
>> "Uri Dimant" wrote:
>> Take a look at
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>>
>>
>> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
>> in
>> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>> >I am planing to implement a disaster recovery site for my enterprise
>> >system
>> > consisting of database servers( sql server 2000) , web servers(IIS)
>> > and
>> > application servers, all on microsoft platforms.
>> > in case of any disaster it should failover to the other server in
>> > other
>> > site.
>> > what about using third party solution like Neverfail or Xosoft ,Vertas
>> > solution for achieving this.
>> >
>> > which you recommend ?
>> >
>> > Pls SHARE your opinion.
>> >
>> > Note:cost is not a constarint.
>> >
>>
>|||I know. But it is December already, so right now it is a good time to test
the technology.
In addition, the original request mentions a SQL Server 2000 instalation.
So, in order to get benefit of database mirroring an upgrade is required,
isn't?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Uri Dimant" wrote:
> Ben
> Database Mirroring will be available for production only in the first half
> 2006.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> >
> > If your requirements are automatic failover without data loss then ...
> >
> > I understand that only Failover Clustering and Database Mirroring provide
> > automatic failover with no data loss. But failover clustering has only one
> > copy of the database. So, for your requirements that leaves database
> > mirroring as your only choice.
> >
> > But here I am talking only about SQL Server technologies. I do not know
> > about choices from other vendors.
> >
> > Benjamin Nevarez, MCDBA, OCP
> >
> >
> >
> >
> > "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> > message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> >> Hi uri,
> >> I am already having cluster,log sipping, replication configured for
> >> database
> >> but what i am looking for is a automatic failover to different site
> >> without
> >> any data loss.
> >>
> >> "Uri Dimant" wrote:
> >>
> >> Take a look at
> >> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> >>
> >>
> >>
> >>
> >>
> >>
> >> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
> >> in
> >> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> >> >I am planing to implement a disaster recovery site for my enterprise
> >> >system
> >> > consisting of database servers( sql server 2000) , web servers(IIS)
> >> > and
> >> > application servers, all on microsoft platforms.
> >> > in case of any disaster it should failover to the other server in
> >> > other
> >> > site.
> >> > what about using third party solution like Neverfail or Xosoft ,Vertas
> >> > solution for achieving this.
> >> >
> >> > which you recommend ?
> >> >
> >> > Pls SHARE your opinion.
> >> >
> >> > Note:cost is not a constarint.
> >> >
> >>
> >>
> >>
> >
> >
>
>|||Hi Guys,
any body used third party tools like veritas,nevefail or xosoft to achieve
this.
"Ben Nevarez" wrote:
> I know. But it is December already, so right now it is a good time to test
> the technology.
> In addition, the original request mentions a SQL Server 2000 instalation.
> So, in order to get benefit of database mirroring an upgrade is required,
> isn't?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Uri Dimant" wrote:
> > Ben
> > Database Mirroring will be available for production only in the first half
> > 2006.
> >
> >
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> > >
> > > If your requirements are automatic failover without data loss then ...
> > >
> > > I understand that only Failover Clustering and Database Mirroring provide
> > > automatic failover with no data loss. But failover clustering has only one
> > > copy of the database. So, for your requirements that leaves database
> > > mirroring as your only choice.
> > >
> > > But here I am talking only about SQL Server technologies. I do not know
> > > about choices from other vendors.
> > >
> > > Benjamin Nevarez, MCDBA, OCP
> > >
> > >
> > >
> > >
> > > "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> > > message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> > >> Hi uri,
> > >> I am already having cluster,log sipping, replication configured for
> > >> database
> > >> but what i am looking for is a automatic failover to different site
> > >> without
> > >> any data loss.
> > >>
> > >> "Uri Dimant" wrote:
> > >>
> > >> Take a look at
> > >> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
> > >> in
> > >> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> > >> >I am planing to implement a disaster recovery site for my enterprise
> > >> >system
> > >> > consisting of database servers( sql server 2000) , web servers(IIS)
> > >> > and
> > >> > application servers, all on microsoft platforms.
> > >> > in case of any disaster it should failover to the other server in
> > >> > other
> > >> > site.
> > >> > what about using third party solution like Neverfail or Xosoft ,Vertas
> > >> > solution for achieving this.
> > >> >
> > >> > which you recommend ?
> > >> >
> > >> > Pls SHARE your opinion.
> > >> >
> > >> > Note:cost is not a constarint.
> > >> >
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >