Does SQL server support failover without sahred disk or external storage

Hi fellow,
I'd like to know if is it possible to configure SQL Server in a cluster enviroment to provide failover, without using shared disks or external storages.
What I wish is setup and cluster to provide failover in case of a hardware malfuction only between servers A and B. The data "integrity" however will be guarantee by my application. I only wish to provide my clients an transparent and automatic way to c
onnect to server B in case of failure of server A, behaving just like the virtual server in a cluster enviroment.
Anyone knows if this is possible?
Cheers,
Eric.
SQL does not have such a feature. The SQL failover cluster model requires a
common dagta store that can be arbitrated between nodes so that a single
node failure is recoverable.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Eric" <anonymous@.discussions.microsoft.com> wrote in message
news:8F02A739-E588-4C27-9CF2-63999EFBE802@.microsoft.com...
> Hi fellow,
> I'd like to know if is it possible to configure SQL Server in a cluster
enviroment to provide failover, without using shared disks or external
storages.
> What I wish is setup and cluster to provide failover in case of a
hardware malfuction only between servers A and B. The data "integrity"
however will be guarantee by my application. I only wish to provide my
clients an transparent and automatic way to connect to server B in case of
failure of server A, behaving just like the virtual server in a cluster
enviroment.
> Anyone knows if this is possible?
> Cheers,
> Eric.
|||Yes, SQL Server does support failover in that situation. It will not
operate exactly like a virtual server in a cluster environment.
You can use either replication or log shipping to create the second copy of
the database on Server B. Each will have latency as far as what data
exists. Each one has different processes for failing over as well as
failing back. If you search back across this newsgroups and the replication
newsgroup for the last 2 months, there will be more than enough information
posted about that subject.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Hi Michel,
The replication and log shipping solves the problem of keeping data between servers ok, but my point is related to the client.
Is there a way to make the client service start using the second server automatically in case of server A failure? For example, my apllication use ODBC to connect to DB_SERVER, wich will be directed to Server A only if it is availble. If not, then DB_SE
RVER will point automatically to Server B. The Client is unware of any change, just like a failover cluster.
Cheers,
Eric
|||Not in the current version of SQL Server. However, database mirroring in
Yukon may be of interest to you. Have a look here:
http://www.microsoft.com/technet/pro...n123121120120.
Of course, the downside is that Yukon won't be available until next year...
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Eric" <anonymous@.discussions.microsoft.com> wrote in message
news:32D7E78D-55B4-4B49-A1FE-2385D41E9BA0@.microsoft.com...
> Hi Michel,
> The replication and log shipping solves the problem of keeping data
between servers ok, but my point is related to the client.
> Is there a way to make the client service start using the second server
automatically in case of server A failure? For example, my apllication use
ODBC to connect to DB_SERVER, wich will be directed to Server A only if it
is availble. If not, then DB_SERVER will point automatically to Server B.
The Client is unware of any change, just like a failover cluster.
> Cheers,
> Eric
|||Nope to the original question and no even to database mirroring.
If using replication or log shipping, you will have to write code into you
application to detect it, redirect, and reconnect.
When Yukon ships and if database mirroring is in the product, when the
primary fails, you will be disconnected. You will then have to reinitiate
the connection. You just won't have to redirect to a different server name.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||From Lubor's presentation at the PASS Summit (public info here), there is
supposed to be client library awareness so that an automatic, transparent
shift happens with database mirroring.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:%23ukY8TiLEHA.3096@.TK2MSFTNGP11.phx.gbl...
> Nope to the original question and no even to database mirroring.
> If using replication or log shipping, you will have to write code into you
> application to detect it, redirect, and reconnect.
> When Yukon ships and if database mirroring is in the product, when the
> primary fails, you will be disconnected. You will then have to reinitiate
> the connection. You just won't have to redirect to a different server
name.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>
|||Yes, there is supposed to be client library awareness. The feature is
currently called "transparent client redirect". The transparent redirect
part is that an application doesn't need to change names. It is called
"redirect". It is not called "reconnect". The information is in the PASS
session you refer to. The same basic information with a few extensions is
also contained in a database mirroring session I did in London at DevWeek as
well as in Vienna at XtremeSQL.
There is also a very big word of caution here since this has the potential
to head the wrong direction. Yukon is still in Beta 1. Beta 1 is still
NDA. The only thing allowed to be discussed is what is publicly released.
Outside of that, there are a small group of people authorized to talk about
it. At this point, it is best to not even discuss Yukon features or
functionality. If there are specific questions on Yukon, they can be asked
in "other venues".
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||I am very aware of my NDA obligations on Yukon. I only discuss items where
I can refer to a public statement by an authorized Microsoft representative,
such as the Beta 1 presentations at PASS.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:%23O$GGamLEHA.3324@.TK2MSFTNGP10.phx.gbl...
> Yes, there is supposed to be client library awareness. The feature is
> currently called "transparent client redirect". The transparent redirect
> part is that an application doesn't need to change names. It is called
> "redirect". It is not called "reconnect". The information is in the PASS
> session you refer to. The same basic information with a few extensions is
> also contained in a database mirroring session I did in London at DevWeek
as
> well as in Vienna at XtremeSQL.
> There is also a very big word of caution here since this has the potential
> to head the wrong direction. Yukon is still in Beta 1. Beta 1 is still
> NDA. The only thing allowed to be discussed is what is publicly released.
> Outside of that, there are a small group of people authorized to talk
about
> it. At this point, it is best to not even discuss Yukon features or
> functionality. If there are specific questions on Yukon, they can be
asked
> in "other venues".
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>

Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 2005 S

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
ThanksI just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>

Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 2005 S

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
Thanks
I just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>

Does SQL Server Browser Service need to be a clustered resource for a Clustered SQL 20

I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
be a clustered resource. It wasn't set up that way, but I was just
wondering.
ThanksI just found out that it is not supported as a clustered resource.
"Steven" <skong@.ap.org> wrote in message
news:uV9w10DHGHA.1728@.TK2MSFTNGP09.phx.gbl...
>I have a SQL Server 2005 CLuster; Does SQL SERVER BROWSER service need to
>be a clustered resource. It wasn't set up that way, but I was just
>wondering.
> Thanks
>sql

Does SQL 2005 in-place upgrade update all nodes?

We have a two node, single instance SQL Server 2000 cluster. If I do an
in-place upgrade to 2005, will it replace the binaries on both nodes, or must
I run the upgrade on each node?
Yes and No.
The SQL storage engine upgrade is cluster aware and will update all nodes
(assuming all nodes are online and working at the time of the upgrade). The
tools installer is NOT cluster aware and will have to be run on each node
independently. Personally, i prefer to load the tools first and then go
back and upgrade the engine.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"steveg" <steveg@.discussions.microsoft.com> wrote in message
news:963FDCFA-1752-4DBA-AA29-CAC4CFFDD705@.microsoft.com...
> We have a two node, single instance SQL Server 2000 cluster. If I do an
> in-place upgrade to 2005, will it replace the binaries on both nodes, or
> must
> I run the upgrade on each node?
sql

Does Sql 2000 Cluster require DTC?

Hello,
Currently I need to deploy a cluster environment for my client. I've
found many topics discussing about whether Sql 2000 cluster requires
DTC to operate, but still see no final answer for it. Can someone
please help me answer this question?
Thanks,
BN
SQL does not require it, but Exchange does. We have dozens of SQL Clusters
running nicely without MSDTC.
You might need it for your applications to use SQL though, check with your
software vendors.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
<buunguyen@.psv.com.vn> wrote in message
news:1128374943.452421.139090@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I need to deploy a cluster environment for my client. I've
> found many topics discussing about whether Sql 2000 cluster requires
> DTC to operate, but still see no final answer for it. Can someone
> please help me answer this question?
> Thanks,
> BN
>
|||Thanks so much for your answer and proof ;-) Rod.
Regards,
Nguyen

Does rolling a cluster create down time?

We have about 40 DB's blackening 40 web sites running on a single
SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the
next I'm wondering exactly what sort of outage our clients would see. Since
the entire cluster rolls in under a minute would there just be a delay on
the web sites with data requests in response from the web/ODBC side or would
there be an ODBC failure. Also, with regards to active web sessions, would
clients mid transaction on the web pages need to restart their transaction
or would there be a short wait during the SQL roll and then they could
proceed with the transaction (or would they need to start all over again).
I guess I'm wondering if I need to add the 1 minute of roll time into our
annual downtime calculation if the clients see an application
failure/unavailability.
On the roll all client connections are lost and must be restarted. As for
what exactly happens, well that depends on the application. If the rows are
returned locally or if they are stored on the web server. And at what stage
in the process each client was in.
Bottom line, in most cases they either hit F5 (refresh) or never notice.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||What the clients see or how it affects their transactions depends solely on
how the client app was written. It must be cluster aware. By that I mean
it must be able to detect a connection failure and reconnect. It must also
be able to resubmit the current transaction as it will be rolled back on the
server side when the cluster comes back up.
Andrew J. Kelly SQL MVP
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||A cluster host transition is exactly like a SQL server stop-start. All
transactions are rolled forward or back at startup. The server is down
during the transition. The client application will see a connection timeout
or a query timeout or a broken connection. Whether the application traps
that or displays that to the end-user depends on the skill of the programmer
who wrote it.
Short answer, a cluster transition is downtime.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||During the failover process, any active connections are broken. For Web browser users, a simple refresh of the Web page should create a new database connection. In a more traditional client/server application, or
one that relies heavily on a middle tier, application designers may want to consider checking to see whether the connection exists, and if not, reconnect. Therefore, whatever the user was working on when the server
went down may not be completed, unless the transaction completes before the server goes down or the transaction is handled within the application.
For more information, see the Knowledge Base article "Q273673 - Virtual Server Client Connections Must be Controlled by Clients" at:
http://support.microsoft.com/?kbid=273673
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Does MS SQL 2005 support Compute Cluster Server /HPC

Does MS SQL 2005 support Compute Cluster Server /HPC? If so where can I find
details?
Thanks
Bill
"William F. Kinsley" <bacardi@.noemail.nospam> wrote in message
news:16D26A57-00B0-4C2F-BC4F-2623C0259612@.microsoft.com...
> Does MS SQL 2005 support Compute Cluster Server /HPC? If so where can I
> find details?
no
See http://www.microsoft.com/hpc for more info.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Denver starting Feb 12th
NYC starting Feb 19th
|||Thank You
"Russ Kaufmann [MVP]" <russ@.clusterhelp.com> wrote in message
news:elVNIsyQHHA.1200@.TK2MSFTNGP02.phx.gbl...
> "William F. Kinsley" <bacardi@.noemail.nospam> wrote in message
> news:16D26A57-00B0-4C2F-BC4F-2623C0259612@.microsoft.com...
> no
> See http://www.microsoft.com/hpc for more info.
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
>

does it means there is still a index there?

i know when I set a primary key for a table.i will get a cluster index.
but if i remove that cluster option on INDEX/KEY OPTION　PAGE.　i still
find i can choose ASC /DESC?
does it means there is still a index there?An index is always created for a primary key constraint. By default this is
a clustered index but you can also choose a non-clustered index (by
deselecting the clustered option). The ASC/DESC option applies to both types
of index.
David Portas
SQL Server MVP
--|||we know, INDEX may some time affect performance of DataBase if we often
update data. why SQL SERVER compel us bind a index to a primary key?|||Because that is by far the fastest and most efficient way to enforce
uniqueness. Without index, SQL-Server would have to do a table scan
whenever a new row is added, just to see if it's primary key is unique.
In addition to that, if you do not update the indexed column(s) or the
column(s) of the clustered index, then the index will not affect UPDATE
performance.
Gert-Jan
why bind a index to a primary key? wrote:
> we know, INDEX may some time affect performance of DataBase if we often updat
e data. why SQL SERVER compel us bind a index to a primary key?
(Please reply only to the newsgroup)

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
http://www.sage-eshop.com
Installing SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:

> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> http://www.sage-eshop.com
>
>

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL200
0
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:

> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>

Docs files in FTDATA

Hi,
I have a SQL Server 2000 cluster, sp 3 in w2k.
When the catalog is reindexed, some documents appears in FTDATA folder. If I
delete the documents, then they reappear in the next indexing.
I'm thinking about to schedule a batch that cleanup this folder, because I
have the FTDATA in the Quorum drive, with no much free space.
Why this is? How can I avoid it?
qwalgrande
What do you mean by documents? Can you open these documents in Word or
notepad?
These documents will be extracted by the indexing process, but on my non
clustered system they are cleaned up.
Some files will remain which are used my mssearch to track where it is in
the indexing process. You shouldn't touch these files.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:6131ACD4-A717-48D6-AC63-4F2FE43B7CA5@.microsoft.com...
> Hi,
> I have a SQL Server 2000 cluster, sp 3 in w2k.
> When the catalog is reindexed, some documents appears in FTDATA folder. If
I
> delete the documents, then they reappear in the next indexing.
> I'm thinking about to schedule a batch that cleanup this folder, because I
> have the FTDATA in the Quorum drive, with no much free space.
> Why this is? How can I avoid it?
> --
> qwalgrande
|||one more point - exactly which subdirectory of ftdata do these files exist
in.
It could be possible that they are eithre configuration files or the actual
index/catalog files themselves.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%238ZUxJKoEHA.2340@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> What do you mean by documents? Can you open these documents in Word or
> notepad?
> These documents will be extracted by the indexing process, but on my non
> clustered system they are cleaned up.
> Some files will remain which are used my mssearch to track where it is in
> the indexing process. You shouldn't touch these files.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
> news:6131ACD4-A717-48D6-AC63-4F2FE43B7CA5@.microsoft.com...
If[vbcol=seagreen]
> I
I
>
|||Hello, Hilary.
I will try to explain it better. These "documents" are the documents that I
had inserted in my indexed image column. In the population, the documents
"pass" for the folder and quickly disappear, but a few documents stay in the
folder and don't cleaned up.
The directory is FTDATA, no subdirectories. I have tried in a nonclustered
server too, whit the same result. Could you help me?
Thanks in advanced.
"Hilary Cotter" wrote:

> one more point - exactly which subdirectory of ftdata do these files exist
> in.
> It could be possible that they are eithre configuration files or the actual
> index/catalog files themselves.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%238ZUxJKoEHA.2340@.TK2MSFTNGP11.phx.gbl...
> If
> I
>
>
|||qwalgrande,
The behavior you are seeing is by design, except for the document files not
being deleted, I *believe* has be acknowledged as a bug by Microsoft and may
(or may not) be fixed in the next Service Pack (SP4) for SQL Sever 2000.
This issue was discovered about a year ago on this newsgroup and the
non-delete of the files acknowledged as a bug by Microsoft, but alas we were
not provided with an actual bug number for tracking purposes. Hopefully,
this will be addressed in the next Service Pack (SP4) for SQL Sever 2000.
Regards,
John
"qwalgrande" <qwalgrande*nospam*@.yahoo.es> wrote in message
news:054B35B9-15F1-4BDF-A193-D03638EA71CC@.microsoft.com...
> Hello, Hilary.
> I will try to explain it better. These "documents" are the documents that
I
> had inserted in my indexed image column. In the population, the documents
> "pass" for the folder and quickly disappear, but a few documents stay in
the[vbcol=seagreen]
> folder and don't cleaned up.
> The directory is FTDATA, no subdirectories. I have tried in a nonclustered
> server too, whit the same result. Could you help me?
> Thanks in advanced.
> "Hilary Cotter" wrote:
exist[vbcol=seagreen]
actual[vbcol=seagreen]
non[vbcol=seagreen]
in[vbcol=seagreen]
folder.[vbcol=seagreen]
because[vbcol=seagreen]

Doc for SQL 2000 Cluster

Hello
Is there any brief howto to configure SQL 2000 Cluster on a VM?
Thanks
Hi Champ,
I found these articles and hope to help.
Title:Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
Title:SQL Server 2000 Clustering Tips
http://www.sql-server-performance.com/clustering_2000.asp
Title:Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/kb/254321/
Regards,
QiDing
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Hemang" <Champ@.nospam.nospam>
| Subject: Doc for SQL 2000 Cluster
| Date: Thu, 22 Feb 2007 08:29:24 -0700
| Lines: 6
| MIME-Version: 1.0
| Content-Type: text/plain;
| format=flowed;
| charset="iso-8859-1";
| reply-type=original
| Content-Transfer-Encoding: 7bit
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Windows Mail 6.0.6000.16386
| X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16386
| Message-ID: <u#yd$YpVHHA.1120@.TK2MSFTNGP02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.clustering
| NNTP-Posting-Host: s0106000dbceff798.ed.shawcable.net 70.74.230.102
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:652
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
| Hello
|
| Is there any brief howto to configure SQL 2000 Cluster on a VM?
|
| Thanks
|
|
|||http://support.microsoft.com/kb/891798
http://support.microsoft.com/kb/840192/en-us
Hope these help.
Sincerely,
Anthony Thomas

"Hemang" <Champ@.nospam.nospam> wrote in message
news:u%23yd$YpVHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Hello
> Is there any brief howto to configure SQL 2000 Cluster on a VM?
> Thanks
>
|||Hi Hemang,
I am just writing to see how everything is going. If you have any updates
or need any further assistance on this issue, please feel free to let me
know. I am glad to be of assistance.
Regards,
QiDing
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Hemang
I am just writing to see how everything is going. If you have any updates
or need any further assistance on this issue, please feel free to let me
know. I am glad to be of assistance.
Regards,
QiDing
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.