Please give me more details on what you are saying to do, I'm just not following how I can accomplish this.
Both servers already have this db, the one in the domain is pushing to the db on the DMZ, and now I need to pull 2 tables from this same db from the db on the DMZ.
I am trying to accomplish this with a Anonymous Pull Subscription, but I don't know how to set it up for no sync.
JUDE
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:ekZ$dCQ$FHA.2392@.TK2MSFTNGP09.phx.gbl...
Jude, to make life simple for your self is there anyway you can restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude
Can you contact me offline. I have a bit of a write up on how to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <judes@.email.uophx.edu> wrote in message news:exbkymo$FHA.356@.TK2MSFTNGP12.phx.gbl...
Please give me more details on what you are saying to do, I'm just not following how I can accomplish this.
Both servers already have this db, the one in the domain is pushing to the db on the DMZ, and now I need to pull 2 tables from this same db from the db on the DMZ.
I am trying to accomplish this with a Anonymous Pull Subscription, but I don't know how to set it up for no sync.
JUDE
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:ekZ$dCQ$FHA.2392@.TK2MSFTNGP09.phx.gbl...
Jude, to make life simple for your self is there anyway you can restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude
|||Yes, absolutely, how do I contact you offline?
If it's easier, you can contact me at your convenience, toll free 1-800-sartomer, extension 4154 or have the operator page Judy Shoop or directly to my office is 610.363.4154.
Thanx!
Jude
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:eMLs6Zp$FHA.3096@.TK2MSFTNGP14.phx.gbl...
Can you contact me offline. I have a bit of a write up on how to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <judes@.email.uophx.edu> wrote in message news:exbkymo$FHA.356@.TK2MSFTNGP12.phx.gbl...
Please give me more details on what you are saying to do, I'm just not following how I can accomplish this.
Both servers already have this db, the one in the domain is pushing to the db on the DMZ, and now I need to pull 2 tables from this same db from the db on the DMZ.
I am trying to accomplish this with a Anonymous Pull Subscription, but I don't know how to set it up for no sync.
JUDE
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:ekZ$dCQ$FHA.2392@.TK2MSFTNGP09.phx.gbl...
Jude, to make life simple for your self is there anyway you can restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_ scripts for the pull subscription & pull agent, for NO SYNC?
Jude
|||Use my email address - but here is the doc I put together.
The requirement is that DATABASE be replicated bi-directionally internally
and externally. There are several options to do this, bi-directional
transactional replication was chosen as it does not modify the schema. Merge
replication, and updateable subscribers all modify the schema with the
addition of a GUID column.
To get around the firewall problem the internal database will replicate to
the external database, and the external database changes will be pulled
internally. The internal server will be configured as an anonymous
subscriber of the external server's publication as a named subscriber will
not work.
Steps required configure replication.
1) connect to the production database, right click on each of the
production tables and set the identity attribute to be not for replication.
Configure the increment to be 2. You will need to modify the following
tables.
TableName1WithIdentityColumn
TableName2WithIdentityColumn
TableName3WithIdentityColumn
TableName4WithIdentityColumn
The best/only way to configure these tables is to right click on them in
Enterprise Manager and set the identity property accordingly. Figure 1 is a
correctly configured table.
2) After all of the tables have been configured, back up the database,
and restore it on the subscriber. Ensure that no users are accessing the
database at this time.
3) Once the database has been restored create the publication on the
Publisher and the Subscriber. Use the attached script for this, editing for
the correct server and database names. - this script is a publication where
the name conflicts section is keep existing table intact, and its a nosync
subscription.
4) Once you have done this you need to run the same script in your
external server. Make sure you have configured your subscriber using its
NetBIOS name in Client Network Utility. A Fully Qualified Domain Name will
not work; it must be a NetBIOS name. Please refer to Figure 2 for an
example.
5) Once you have configured replication, deploy the replication stored
procedures on both sides. Please refer to the attached script to do this.
(this script was generated by running sp_scriptpublicationcustomprocs
6) Once the replication stored procedures are in place you have to
reset the identity seed on both sides. We will assign even numbers to the
internal server, and external numbers to the external server.
7) To do this issue the following commands. Note that TableName5 is the
only table which has to be fixed, and the fix is illustrated in red:
dbcc checkident('TableName5')
--Checking identity information: current identity value '8854', current
column value '8854'.
--DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
--ok as the number is even
dbcc checkident('TableName5')
--Checking identity information: current identity value '448', current
column value '448'.
--DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
--ok as the number is even
dbcc checkident('TableName6)
--Checking identity information: current identity value '19', current column
value '19'.
--DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
--not ok as the number is odd
--incrementing it up to the nearest even number
dbcc checkident('TableName7', reseed,20)
--Checking identity information: current identity value '19', current column
value '20'.
--DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
--now correct
dbcc checkident('TableName8')
--Checking identity information: current identity value '32', current column
value '32'.
--DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
--ok as the number is even
8) Repeat for the Subscriber (external server). This time all the
identity values should be reseeded to the next highest odd number.
9) Schedule the distribution agents to start every 5 minutes - this
will guarantee an restart in the event of failure.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message
news:eCOXKey$FHA.1408@.TK2MSFTNGP15.phx.gbl...
Yes, absolutely, how do I contact you offline?
If it's easier, you can contact me at your convenience, toll free
1-800-sartomer, extension 4154 or have the operator page Judy Shoop or
directly to my office is 610.363.4154.
Thanx!
Jude
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eMLs6Zp$FHA.3096@.TK2MSFTNGP14.phx.gbl...
Can you contact me offline. I have a bit of a write up on how to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <judes@.email.uophx.edu> wrote in message
news:exbkymo$FHA.356@.TK2MSFTNGP12.phx.gbl...
Please give me more details on what you are saying to do, I'm just not
following how I can accomplish this.
Both servers already have this db, the one in the domain is pushing to
the db on the DMZ, and now I need to pull 2 tables from this same db from
the db on the DMZ.
I am trying to accomplish this with a Anonymous Pull Subscription, but I
don't know how to set it up for no sync.
JUDE
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ekZ$dCQ$FHA.2392@.TK2MSFTNGP09.phx.gbl...
Jude, to make life simple for your self is there anyway you can
restore the publishing database to the subscriber and do a no-sync?
This will make life much easier for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message
news:%23%23RCIYP$FHA.264@.tk2msftngp13.phx.gbl...
How can I setup an anonymous pull subscription, using the sp_
scripts for the pull subscription & pull agent, for NO SYNC?
Jude
Showing posts with label provide. Show all posts
Showing posts with label provide. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
highly appreciated !
You are the DBA for a busy order entry database. You want to provide a
method for automatically backing up the transaction log for you database in
case it becomes more than 90 percent full prior to the next regularly
scheduled transaction log backup. What is the best way to accomplish this?
1.. Create an alert in Performance Monitor to call an OSQL script to
backup log the transaction log when it becomes more than 90% full.
2.. Create al alert in SQL Enterprise Manager that will call a job to
backup the transaction log when it becomes more than 90% full.
3.. Create an alert in SQL Enterpise Manager that will call an OSQL script
to backup the transaction log when it becomes more than 90% full.
4.. Create an alert in Performance Monitor that will call SQLALRTR.EXE to
trigger a SQL Server alert to backup the transaction log when it becomes
more than 90% full.
5.. Create a schedule transaction log backup for every 10 minutes.
6.. You cannot do this.
"Roy" schrieb:
> You are the DBA for a busy order entry database. You want to provide a
> method for automatically backing up the transaction log for you database in
> case it becomes more than 90 percent full prior to the next regularly
> scheduled transaction log backup. What is the best way to accomplish this?
> 1.. Create an alert in Performance Monitor to call an OSQL script to
> backup log the transaction log when it becomes more than 90% full.
> 2.. Create al alert in SQL Enterprise Manager that will call a job to
> backup the transaction log when it becomes more than 90% full.
> 3.. Create an alert in SQL Enterpise Manager that will call an OSQL script
> to backup the transaction log when it becomes more than 90% full.
> 4.. Create an alert in Performance Monitor that will call SQLALRTR.EXE to
> trigger a SQL Server alert to backup the transaction log when it becomes
> more than 90% full.
> 5.. Create a schedule transaction log backup for every 10 minutes.
> 6.. You cannot do this.
6 is out of question!!!
2 sounds reasonable. Attention: That will not be an event alert (there is no
event / error code for 'log 90% full') but a performance condition alert!
method for automatically backing up the transaction log for you database in
case it becomes more than 90 percent full prior to the next regularly
scheduled transaction log backup. What is the best way to accomplish this?
1.. Create an alert in Performance Monitor to call an OSQL script to
backup log the transaction log when it becomes more than 90% full.
2.. Create al alert in SQL Enterprise Manager that will call a job to
backup the transaction log when it becomes more than 90% full.
3.. Create an alert in SQL Enterpise Manager that will call an OSQL script
to backup the transaction log when it becomes more than 90% full.
4.. Create an alert in Performance Monitor that will call SQLALRTR.EXE to
trigger a SQL Server alert to backup the transaction log when it becomes
more than 90% full.
5.. Create a schedule transaction log backup for every 10 minutes.
6.. You cannot do this.
"Roy" schrieb:
> You are the DBA for a busy order entry database. You want to provide a
> method for automatically backing up the transaction log for you database in
> case it becomes more than 90 percent full prior to the next regularly
> scheduled transaction log backup. What is the best way to accomplish this?
> 1.. Create an alert in Performance Monitor to call an OSQL script to
> backup log the transaction log when it becomes more than 90% full.
> 2.. Create al alert in SQL Enterprise Manager that will call a job to
> backup the transaction log when it becomes more than 90% full.
> 3.. Create an alert in SQL Enterpise Manager that will call an OSQL script
> to backup the transaction log when it becomes more than 90% full.
> 4.. Create an alert in Performance Monitor that will call SQLALRTR.EXE to
> trigger a SQL Server alert to backup the transaction log when it becomes
> more than 90% full.
> 5.. Create a schedule transaction log backup for every 10 minutes.
> 6.. You cannot do this.
6 is out of question!!!
2 sounds reasonable. Attention: That will not be an event alert (there is no
event / error code for 'log 90% full') but a performance condition alert!
Highlight row
Hi,
After the report is rendered in the report viewer control (In windows forms application), I want to provide user with a facility to highlight rows (data). Is it possible with SSRS/Report viewer?
For example, amongst the list of 100 invoices, user should be able to highlight 10 invoices.
Thanks in advance.
Paresh
Not real easily. The only approach I can think of is to have a multi-value parameter on the report which contains invoice numbers. The user would need to select invoice report parameter values equal to the invoice numbers to highlight, then rerun the report checking to see if the row matched the selected report parameter values.In other words, not real easily.
Highlight Results from search
>From what I have so far, Sql Server does not provide a way to return
its query results hits in a highlighted format. I was able to
programmatically get this working for simple searches, where I simply
do a find and replace based on the search criteria. But this will not
work for plural results or irregular type finds. For example, if I do
a search for "mouse", and sql server returns "mice", I have no way of
knowing to highlight "mice". I read that this can be done using
lemmatizer and stemmer algorithms. Is there an easier way of doing
this? If not, does anyone know of any .net api's or code I can get
started with?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179421330.863970.28850@.p77g2000hsh.googlegro ups.com...
> its query results hits in a highlighted format. I was able to
> programmatically get this working for simple searches, where I simply
> do a find and replace based on the search criteria. But this will not
> work for plural results or irregular type finds. For example, if I do
> a search for "mouse", and sql server returns "mice", I have no way of
> knowing to highlight "mice". I read that this can be done using
> lemmatizer and stemmer algorithms. Is there an easier way of doing
> this? If not, does anyone know of any .net api's or code I can get
> started with?
> Thanks
>
sql
its query results hits in a highlighted format. I was able to
programmatically get this working for simple searches, where I simply
do a find and replace based on the search criteria. But this will not
work for plural results or irregular type finds. For example, if I do
a search for "mouse", and sql server returns "mice", I have no way of
knowing to highlight "mice". I read that this can be done using
lemmatizer and stemmer algorithms. Is there an easier way of doing
this? If not, does anyone know of any .net api's or code I can get
started with?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179421330.863970.28850@.p77g2000hsh.googlegro ups.com...
> its query results hits in a highlighted format. I was able to
> programmatically get this working for simple searches, where I simply
> do a find and replace based on the search criteria. But this will not
> work for plural results or irregular type finds. For example, if I do
> a search for "mouse", and sql server returns "mice", I have no way of
> knowing to highlight "mice". I read that this can be done using
> lemmatizer and stemmer algorithms. Is there an easier way of doing
> this? If not, does anyone know of any .net api's or code I can get
> started with?
> Thanks
>
sql
Friday, March 9, 2012
high availability
Does anyone know any application which can provide high availability
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > Does anyone know any application which can provide high availability
> > solution for SQL2000? Thanks.
> >
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > Does anyone know any application which can provide high availability
> > solution for SQL2000? Thanks.
> >
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>
high availability
Does anyone know any application which can provide high availability
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/d...ering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/d...
ver_8elj.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/d...9v.a
sp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/d...lj.asp
.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/d...ering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/d...
ver_8elj.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/d...9v.a
sp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/d...lj.asp
.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>
Subscribe to:
Posts (Atom)