I need some advice / help on a DAS system ( at least this is what I think I need hardware wise to complete this and pull my butt of out the fire). ...

Bill

12-17-2003 03:09 PM
Jason

hello all Can I add another IP address resource to a clustered SQL 2000 virtual server so that it can listen on two addresses ? Thanks Alice

Alice Spencer

12-16-2003 05:42 PM
Kevin McDonnell [MSFT]

Folks, My current environment is Win2K and SQL 2K clustered in domain A. Need to migrate Cluster to domain B. Both domains are AD Can anyone point me...

Bob C

12-16-2003 05:41 PM
Kevin McDonnell [MSFT]

Hi Guys, i am having sql server 2000 fail over cluster but my sql server full text search service is shown as failed in cluster administrator ? all...

biju george

12-16-2003 03:09 PM
Bob C

Hello, I've set up a test active/passive cluster with sql 2000 and am trying to run through some disaster recovery scenarios. First I am trying...

Greg

12-16-2003 03:04 PM
Bob C

I have encountered something odd and am hoping someone can give me a hand. A clustered server was set up with the 3 partitions 1 quorum 2 data 3...

Eric G

12-16-2003 11:33 AM
Eric G

We receive the following error using SQL 7: Cannot create more than one clustered index on table 'Profile'. Drop the existing clustered index...

Mike

12-16-2003 11:13 AM
Kalen Delaney

hello to every body. i have got a cluster system. windows 2000 Advanced Server SP4. In the node A , I am installing the SQL SERVER 2000 ENTERPRISE...

Charly

12-16-2003 06:21 AM
Charly

We are in the process of building a single instance cluster on Win2K Advanced Server/SS2K Enterprise. Does Microsoft support NIC Teaming for the...

Denise McInerney

12-15-2003 03:40 PM
Denise McInerney

Hi all, we have two web servers talking to a clustered sql server 2000. all machines are running on win2k3. The application running on the...

Richard

12-15-2003 10:26 AM
Uttam Parui[MS]

I've noticed that dbcc shrinkdatabase does not shrink the log file. How do we shrink the log file? Thanks.

Dean

12-15-2003 09:53 AM

I know this topic has been covered many times, but i can't find the answer anywhere. I've been through the readme, books online and all through the...

Jeff Zavada

12-12-2003 01:58 PM
Jeff Zavada

I have several tables that are heavily fragmented in the database. The database maintenance plan I have selected the Optimization and Integrity...

Dean

12-11-2003 04:37 PM
Allan Hirt

I am rolling out a sql sever for a small business (30 users). Is there an advantage in terms of redundancy (failover/cluster) in purchasing sql...

Greg Gibson

12-11-2003 01:58 PM
Uttam Parui[MS]

Hello, Sorry for reposting this issue but I never received a response to my follow up last week(on the 3rd). I am having a problem restoring...

Greg

12-11-2003 01:50 PM
Uttam Parui[MS]

Is there an article on how to move the quorum from one drive to another or do you have to set the cluster back up?

Thomas Rae

12-10-2003 03:47 PM
Thomas Rae

Hi, I will have to change whole IP structure (different IP address and different network mask) in my company and it also means to change an...

Jan West

12-10-2003 01:08 PM
Rand Boyd [MS]

When setting up your clustering design , what would be the main reasons for adding new instances to the pre-existing ones? Basically I need a list...

Steve

12-10-2003 12:41 PM
Linchi Shea

Hi, Can anyone point me in the right direction for some good information on real life scenarios in clustering SQL 2000? I'm basically looking at...

Dave LLoyd

12-10-2003 09:49 AM
Geoff N. Hiten

Our Configuration....(Win2k Advanced SP4+ Post SP4 critical patches, SQL server 7.0 SP4, Active/passive cluster) When we try to move the resources of...

Bruce Gilbert

12-09-2003 07:09 PM
Cindy Gross

Can someone help me here, I'm geting this while trying to execute SLS. Backing up t to DISK=\\db2d\c$\t_20031208_0734_LOG.BAK BACKUP LOG...

John Smith

12-09-2003 02:32 PM
Geoff N. Hiten

Reposting this question to microsoft.public.sqlserver.clustering (was originally in microsoft.public.sqlserver.jdbcdriver): From:...

Carb Simien [MSFT]

12-09-2003 02:08 PM
Cindy Gross

Hi, I have an active / active 2 node cluster running windows 2k and SQL 2k. Both instances will succesfully come online and run concurrently on the...

Alan Baird

12-09-2003 02:03 PM
Cindy Gross

All, Trying to find out if anyone has used the MS SQL within the Cisco Call Manager App. Currently I get a error messges that points back to...

Tom

12-09-2003 10:02 AM

Hi, I'm a consultant for some small company and they purchased a MS SQL Standard Edition, I think it's MS SQL 2000, I think it's latest .. I can...

ml@db.nexgen.com

12-08-2003 06:48 PM
John Smith

Is it possible to move the master db from one drive to another in a cluster? I am running a active/passive configuration. Currently I have the all...

Thomas Rae

12-08-2003 05:09 PM
Allan Hirt

Did anyone use the 64 bit version in production with large databases? Is it a better price/performance than the 32 bits version? Any information if...

Daniel P.

12-08-2003 03:18 PM
Allan Hirt

I'm restore a small SQL Server 2000 database (1.5 GB) that was created on the same SAN but a different Cluster and Server. This restore takes...

Jim

12-07-2003 06:40 PM
Allan Hirt

I am trying to query the following table. Select @@servername outputs : TEXBDVS01VSQL3\VSQL_XYZ select * from...

Frank

12-06-2003 11:17 AM
Geoff N. Hiten

Hi i have installed our new Failover Cluster, based on Windows 2003 and SQL 2000 SP3. This looks like CLUSTERSRV1 - 10.1.1.1 (Active) CLUSTERSRV2 -...

alex

12-06-2003 07:11 AM
alex

We have a cluster setup using 5 servers and 3 environment (PRD, QAT and DEV): PRD1, PRD2, QAT1, QAT2, DEV1. All servers are running Windows 2003. ...

michael [multnomah county]

12-05-2003 02:22 PM
Geoff N. Hiten

When trying to create a database on a cluster node with drives D: Data and F: Log the following error occurs. Server: Msg 5184, Level 16, State 2,...

Folke

12-05-2003 12:42 PM
Rand Boyd [MS]

We have a cluster setup using 5 servers and 3 environments (PRD, QAT and DEV): PRD1, PRD2, QAT1, QAT2, DEV1. All servers are running Windows 2003. ...

michael [multnomah county]

12-05-2003 10:03 AM
Allan Hirt

Hi, al I am installing SQL2K Cluster on Win2003 and getting "Another Virtual Server of the same name exists on the network error" My SQL2K Cluster...

Oleg

12-04-2003 05:06 PM
Oleg

Hello, I've been a Microsoft product user and developer for the longest time, but this time my boss has realized that the only way to scale...

OhNoIsLinux

12-04-2003 05:01 PM
Linchi Shea

I am currently working as a DBA and am interestered in learning about Clustering. I can't use the systems at my work place to implement and test it...

Scott Bryan

12-04-2003 04:48 PM
Linchi Shea

I am trying to install SQL Server 2000 on a two-node Windows 2000 cluster. I have a few questions about the procedure: 1. When I installed the...

Eric Caron

12-04-2003 03:21 PM
Eric Caron

Can anyone tell me where I can find documentation of how to setup a cluster under win2000 or win2003 and I would like ot run SQL on it. Thanks

David Saim

12-04-2003 02:50 PM
Cindy Gross

I have been searching on MS, but haven't found the answer. I am in the process of setting up a 2 node SQL Cluster (Active/Passive). I know I have...

Juan Segura

12-04-2003 01:42 PM
Rand Boyd [MS]

Hi Can you explain me how to configure sql 2000 enterprise cluster for active active with one single data base . Our main aim for sql cluster is...

Hemant Dhamane

12-04-2003 12:05 PM
Linchi Shea

1. when install SQL Server 2000 on windows 2003 , SP2 or earlier willnot be supported . But if you ignore this message , install SP3 , No issue . 2....

rainbow

12-04-2003 06:11 AM
Neil Pike

Hello I have two servers in my cluster setup (win2K), each with 8GB RAM. I intend to run two SQL 2000 instances, one on each node. All after a bit...

Jeff Johnson

12-03-2003 01:31 PM
Jeff Johnson

I am trying to login to SQL with a database account and it fails if I am logged into my local desktop as a local user. If I am logged in with my...

Derek

12-03-2003 09:41 AM
Rand Boyd [MS]

Hi, I have a SQL2K cluster (with Windows 2000 Advanced Server) with a single instance. I would like to add a second instance, and I'm asking what are...

Chiara

12-03-2003 07:45 AM
Linchi Shea

We are using W2k, SQL2K, clustered, active-active. We have setup a new clustered sql environment. I am migrating databases and wondering what will...

Claudia

12-03-2003 07:36 AM
Nayan

Nueva Aplicación para Crear y actualizar Bases de Datos en MSDE y SQL Server. Ver http://www.gratisweb.com/guillecangas

Forte

12-03-2003 03:33 AM
Forte

I have installed SQL2000 sp3 on w2K3. When I first tried to connect from a W2K (sp3, MDAC 2.7) web server I received an error MSDTC on "server" is...

Gary Corless

12-02-2003 08:15 PM
Cindy Gross

Hi, I think our sql cluster has a memory leak as we are getting this error after the server has been running sometime and the our iis servers lose...

Tiffany

12-02-2003 08:09 PM
Cindy Gross

Hello: I want to extend the SQL server volume (SAN disk) as the volume is getting nearly full. Can anyone recommend a procedure that impacts little...

doc pisapati

12-02-2003 06:21 PM
Milan Pavlovic

I set up log shipping using the maintenance plan wizard. Everything seems to have setup properly. The transaction log backups work properly. The...

Joshua Lakin

12-02-2003 02:45 PM