|
test
test ...
Sat, 7 Aug 2004 10:42:50 -0700
|
What happens to application during failover?
Hi,
Our customer has is runnning SQL server standard and they
have clients that access the database.
We are moving them to SQL Server Enterprise in an
Active/Passive configuration.
My questions is what happens when the application connects
to the database, it starts doing a series of reads, and a
...
Fri, 6 Aug 2004 10:46:48 -0700
|
Number of databases on a virtual server
Is there a limit to the number of databases exposed through a virtual server?
I'm looking at porting over 200 databases from 12 different servers into a clustered environment and want to minimize the number of SQL Server installs that need to be performed on the cluster.
Thanks in advance.220 15572 <0e3a01c47 ...
Thu, 5 Aug 2004 14:21:03 -0700
|
Installing SQL 2000 on Windows Server 2003
I am trying to install SQL 2000 on a Cluster Server Node
1. MS - Support informed me that I should install this as
a Virtual Server. However, Virtual server is grayed
out. This is a SQL 2000 Standard edition. I do have SLQ
Developer Edition. Does the Version matter here?
I understand their is a pro ...
Thu, 5 Aug 2004 07:56:56 -0700
|
Question about SQL cluster
Question about SQL cluster
We currently have a SQL cluster with two nodes (active/passive). The
transaction logs are currently on the same RAID partition as the databases,
and we're looking to move them off to their own partition. We are planning
to do this by purchasing five new Ultra SCSI 3 15,000 rpm ...
Wed, 4 Aug 2004 11:36:50 -0700
|
Maybe here is better: Inserting deleted rows from a trigger to a SQL Linked Server
Hello, I have a table in my SQLServer1 (SQL2000) this table has a Trigger
For Delete
The content of the trigger is:
insert into SQL2.myDb.dbo.myTable select * from deleted
The SQL2 is a linked SQL2000 Server
But, when I delete one row from myTable the query never end and hang the EM
or QA
When I ...
Wed, 4 Aug 2004 14:21:18 -0400
|
Setting up replication on an existing cluster-share resource quest
I need to set up transactional replication on an existing cluster. Using the replication wizard it first creates the distributor and publisher on the same machine (as per my need) and sets up the REPLData folder as a share. Since this folder is created by the Wizard, how can I have it be recognized as a cluster re ...
Wed, 4 Aug 2004 08:27:04 -0700
|
sql 2000 vs installation
hi everyone
I am installing SQL 2000 on a single node cluster
but after sometime that the virtual server resource installation message
shows up, an error occures and
the installation rolls back.
during the installation as I notice in cluster administrator,
all the required resources are installed but when att ...
Wed, 4 Aug 2004 15:33:54 +0430
|
Nick Berg Found Alive
Conspiracy theories of Nick Berg being alive and well in Iraq have today been proven true. Aljazeera have released video footage of the supposedly beheaded American captive. The clip was first "discovered" on an Islamic website in Malaysia and has now been released by
American Journalists colaborating with Alja ...
Tue, 03 Aug 2004 22:48:40 GMT
|
Cluster and Instances
I have been installed a cluster
SQLSERVER1
and
SQLSERVER2\SQL2
When SQL1 fail, SQL2 take the SQL instance and vice-versa
My Problem is that the SQLSERVER1 don't have a associated instance like SQL2
I want to configure my SQLSERVER1 to access through the instance name =
SQLSERVER1\SQL1
I need to reinst ...
Tue, 3 Aug 2004 14:03:40 -0400
|
SP3 on instance not in cluster
We have installed sp3 on the virtual server with no problems. Then we added a named instance which is not in the cluster. When trying to upgrade the instance to sp3, the option to choose the named instance is not available and we can only apply sp3 to the virtual server. When we check the version of the instance ...
Tue, 3 Aug 2004 07:45:05 -0700
|
SQL cluster monitoring
I have two questions regarding SQL Server Monitoring:
1. How can we differentiate between standalone SQL Server and Clustered SQL Server?
2. How can we identify the members of a cluster and their roles ? Is it possible through WMI queries ?
Thanks in advance. ...
Tue, 3 Aug 2004 04:35:01 -0700
|
Adding a new node to a SQL server cluster
I need to add a second node to a SQL Server Cluster.
What i have to do?
I have join the second node using Cluster Administrator.
I don't see any resource..
I need to manually recreate disks resources in Cluster Administrator?
I need to reinstall SQL Server?
Thanks.
...
Tue, 3 Aug 2004 13:04:30 +0200
|
VMWare 4.5 and SQL clustering
I wanto to make a SQL cluster using VMWare Workstation 4.5.
I need to create a SCSI shared storae device to use witj my cluster.
How can i make this?
I know it was possible using VMWare Workstation 4.0...
Thanks.
...
Tue, 3 Aug 2004 11:26:59 +0200
|
Failover from client POV
When an instance fails over in a cluster from Server A to Server B, does the client detect the outage or lose any information if it's in the middle of a transaction? Or does SQL Server remember the transaction, rollback the database, fail over the instance and restart the transaction? Thanks. ...
Mon, 2 Aug 2004 12:45:21 -0700
|