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.co...g_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.co...g_shipping.asp
>
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>
>
|||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...[vbcol=seagreen]
> 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:
|||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...
>
|||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...
>
>
|||Hi Guys,
any body used third party tools like veritas,nevefail or xosoft to achieve
this.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
2012年3月8日星期四
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.c...og_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.c...og_shipping.asp
>
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>
>|||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...[vbcol=seagreen]
> 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:
>|||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...
>|||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 ha
lf
> 2006.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
>
>|||Hi Guys,
any body used third party tools like veritas,nevefail or xosoft to achieve
this.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
>
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.c...og_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.c...og_shipping.asp
>
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>
>|||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...[vbcol=seagreen]
> 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:
>|||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...
>|||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 ha
lf
> 2006.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
>
>|||Hi Guys,
any body used third party tools like veritas,nevefail or xosoft to achieve
this.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> 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:
>
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.
> > >> >
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >
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.
> > >> >
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >
2012年2月24日星期五
Disable Windows Authentication mode in WDA
Hi,
I have installed MS SQL Server 2005 Express Edition, and SQL Web Data
Administrator on my Windows 2003 webserver with IIS 6.0
Everything works fine but I want to deny the users to log on WDA using
Windows Integrated authentication.
At the moment when i open http://ipaddress/webadmin in IE, I get
following textboxes:
Username: SERVERNAME\Administrator (disabled / greyed out)
Password: <blank> (disabled / greyed out)
Server: (local)
and following Radio Buttons:
Authentication Method: Windows Integrated (selected by default)
SQL Login
If I change he Server textbox value from (local) to server\instancename
and click login, it logs me in straight away where I can perform any
admin functions
I dont want any user to log on using windows integrated authentication.
Is there any way around this problem? I dont want my system to get
hacked either, so cant just change default.aspx file and then allow
hackers still to point to my server with some default variable values
and get access
Thanks in advance.
Regards
You cannot disable Windows Authentication mode (:. If you allow the user
logon to the compuer, where SQL Server runs, as administrator, that user can
do anything the SQL Server. Period. So, simply guard that computer's
administrator account as tight as you can. If the you logon the any other
account to the computer, as long as you did not give access to SQL Server to
those user accounts, the SQL Server will be fine. So, you see, if you
developed some solution that uses SQL Server/Express and you delevered it to
your clients. As long as your clients have full right on their computers
(administrator), they can get into the SQL Server/Express you delevered.
<gogaz@.rediffmail.com> wrote in message
news:1161030857.258517.78090@.i42g2000cwa.googlegro ups.com...
> Hi,
> I have installed MS SQL Server 2005 Express Edition, and SQL Web Data
> Administrator on my Windows 2003 webserver with IIS 6.0
> Everything works fine but I want to deny the users to log on WDA using
> Windows Integrated authentication.
> At the moment when i open http://ipaddress/webadmin in IE, I get
> following textboxes:
> Username: SERVERNAME\Administrator (disabled / greyed out)
> Password: <blank> (disabled / greyed out)
> Server: (local)
> and following Radio Buttons:
> Authentication Method: Windows Integrated (selected by default)
> SQL Login
> If I change he Server textbox value from (local) to server\instancename
> and click login, it logs me in straight away where I can perform any
> admin functions
> I dont want any user to log on using windows integrated authentication.
> Is there any way around this problem? I dont want my system to get
> hacked either, so cant just change default.aspx file and then allow
> hackers still to point to my server with some default variable values
> and get access
> Thanks in advance.
> Regards
>
|||Thanks for the reply. I have sorted out the problem now. Actually when
I downloaded WDA from
http://www.microsoft.com/downloads/d...displaylang=en
and installed it on server, it created a folder Samples under
C:\Program Files\Microsoft SQL Server Tools\Microsoft SQL Web Data
Administrator
In that folder I found source code application for WDA. So I opened it
in VS2003 and updated it as per my requirement. Wicked application this
is!!
I will upload it on my server and will post the link here soon I have
updated it further and tested it myself
Regards
Norman Yuan wrote:[vbcol=seagreen]
> You cannot disable Windows Authentication mode (:. If you allow the user
> logon to the compuer, where SQL Server runs, as administrator, that user can
> do anything the SQL Server. Period. So, simply guard that computer's
> administrator account as tight as you can. If the you logon the any other
> account to the computer, as long as you did not give access to SQL Server to
> those user accounts, the SQL Server will be fine. So, you see, if you
> developed some solution that uses SQL Server/Express and you delevered it to
> your clients. As long as your clients have full right on their computers
> (administrator), they can get into the SQL Server/Express you delevered.
> <gogaz@.rediffmail.com> wrote in message
> news:1161030857.258517.78090@.i42g2000cwa.googlegro ups.com...
I have installed MS SQL Server 2005 Express Edition, and SQL Web Data
Administrator on my Windows 2003 webserver with IIS 6.0
Everything works fine but I want to deny the users to log on WDA using
Windows Integrated authentication.
At the moment when i open http://ipaddress/webadmin in IE, I get
following textboxes:
Username: SERVERNAME\Administrator (disabled / greyed out)
Password: <blank> (disabled / greyed out)
Server: (local)
and following Radio Buttons:
Authentication Method: Windows Integrated (selected by default)
SQL Login
If I change he Server textbox value from (local) to server\instancename
and click login, it logs me in straight away where I can perform any
admin functions
I dont want any user to log on using windows integrated authentication.
Is there any way around this problem? I dont want my system to get
hacked either, so cant just change default.aspx file and then allow
hackers still to point to my server with some default variable values
and get access
Thanks in advance.
Regards
You cannot disable Windows Authentication mode (:. If you allow the user
logon to the compuer, where SQL Server runs, as administrator, that user can
do anything the SQL Server. Period. So, simply guard that computer's
administrator account as tight as you can. If the you logon the any other
account to the computer, as long as you did not give access to SQL Server to
those user accounts, the SQL Server will be fine. So, you see, if you
developed some solution that uses SQL Server/Express and you delevered it to
your clients. As long as your clients have full right on their computers
(administrator), they can get into the SQL Server/Express you delevered.
<gogaz@.rediffmail.com> wrote in message
news:1161030857.258517.78090@.i42g2000cwa.googlegro ups.com...
> Hi,
> I have installed MS SQL Server 2005 Express Edition, and SQL Web Data
> Administrator on my Windows 2003 webserver with IIS 6.0
> Everything works fine but I want to deny the users to log on WDA using
> Windows Integrated authentication.
> At the moment when i open http://ipaddress/webadmin in IE, I get
> following textboxes:
> Username: SERVERNAME\Administrator (disabled / greyed out)
> Password: <blank> (disabled / greyed out)
> Server: (local)
> and following Radio Buttons:
> Authentication Method: Windows Integrated (selected by default)
> SQL Login
> If I change he Server textbox value from (local) to server\instancename
> and click login, it logs me in straight away where I can perform any
> admin functions
> I dont want any user to log on using windows integrated authentication.
> Is there any way around this problem? I dont want my system to get
> hacked either, so cant just change default.aspx file and then allow
> hackers still to point to my server with some default variable values
> and get access
> Thanks in advance.
> Regards
>
|||Thanks for the reply. I have sorted out the problem now. Actually when
I downloaded WDA from
http://www.microsoft.com/downloads/d...displaylang=en
and installed it on server, it created a folder Samples under
C:\Program Files\Microsoft SQL Server Tools\Microsoft SQL Web Data
Administrator
In that folder I found source code application for WDA. So I opened it
in VS2003 and updated it as per my requirement. Wicked application this
is!!
I will upload it on my server and will post the link here soon I have
updated it further and tested it myself
Regards
Norman Yuan wrote:[vbcol=seagreen]
> You cannot disable Windows Authentication mode (:. If you allow the user
> logon to the compuer, where SQL Server runs, as administrator, that user can
> do anything the SQL Server. Period. So, simply guard that computer's
> administrator account as tight as you can. If the you logon the any other
> account to the computer, as long as you did not give access to SQL Server to
> those user accounts, the SQL Server will be fine. So, you see, if you
> developed some solution that uses SQL Server/Express and you delevered it to
> your clients. As long as your clients have full right on their computers
> (administrator), they can get into the SQL Server/Express you delevered.
> <gogaz@.rediffmail.com> wrote in message
> news:1161030857.258517.78090@.i42g2000cwa.googlegro ups.com...
订阅：
博文 (Atom)