all groups > sql server clustering > october 2006 > threads for october 8 - 14, 2006
Filter by week: 1 2 3 4 5
MSI unable to start the SQL instance service
Posted by Mehul at 10/13/2006 12:17:01 PM
Hi,
I am deploying a SQL on a three node active cluster setup. Each node will
have a SQL instance running in the cluster virtual server context. This is
the baseline setup required for deploying application databases on the three
SQL instances. Application databases are deployed using an MSI ... more >>
Create databases in a cluster
Posted by SAM at 10/12/2006 1:16:02 PM
I am trying to create a database but it failes when creating the log file.
Q:\ quorum drive
H:\data
I:\log
The message I get on the I:\
Cannot use file 'I:\Log\rentclicks_Log.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
... more >>
Database Mirror in a SQL cluster
Posted by SAM at 10/12/2006 12:22:01 PM
I read that you can implement DB mirror in a cluster. However, someone else
said that you cannot. Does anyone have any ideas which is correct?... more >>
Configure Integration Services on a Cluster
Posted by Brad Baker at 10/12/2006 2:22:06 AM
We are attempting to setup Integration Services on a Cluster per the
following article: http://msdn2.microsoft.com/en-us/library/ms345193.aspx
We have the following Cluster Groups/resources
"Cluster Group"
Disk Q - Quorum
Disk R - MSDTC
MSDTC
MSDTC IP Address
Cluster Name
Cluster IP
... more >>
Transaction Log Backup
Posted by Franco at 10/12/2006 1:52:02 AM
Hi all,
We have many databases to manage and my question is related to T-Log backup.
At the moment we take t-log backup every 1 hour but on different time for
each database.
For exaample for db1 we take t-log backup at 7.01 AM every hour until 19.01
PM and for db2 we take backup at 7.05 AM ... more >>
Can one instance listen on multi IP Addresses?
Posted by Chen at 10/11/2006 8:36:01 AM
Hi Everybody,
Is it possible to configure one virtual SQL server named instance to listen
on multi IP Address those additional IP Addresses associate with different
virtual SQL network name?
At the result like for example: SQL Server 2005 EE installed on (Windows
2003 64 bit OS cluster s... more >>
Question about setup
Posted by SAM at 10/11/2006 8:05:03 AM
what accounts are required for SQL cluster setup?
I was trying to install SQL Server and ran into some prompts that I did not
see in the books that I read about SQL cluster setup.
I know about SQLservice account. However, I didn't know it requires a domain
group for each service, SQL Serve... more >>
IP Restructuring for SQL Server Cluster
Posted by bass_player at 10/10/2006 3:59:01 AM
We are planning to have our IPs restructured on our disaster recovery site
(DR) because of some business policies and requirements. We are running an
active-passive SQL Server 2000 Cluster environment on both sites. I am
running log shipping on this particular environment. Is there anything... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Migrating Clusters
Posted by Steve at 10/10/2006 3:30:40 AM
Hi All,
We have a 2 node cluster running SQL Server 2000 on Windows 2000 which
needs replacing. The nature of our business is 24 hour operation, so
the downtime to do such needs to be as small as possible.
We have a new cluster ready and waiting in our data centre that is
built on Windows 2... more >>
Non domain user recive acess denided error
Posted by Ido friedman at 10/9/2006 7:12:02 AM
I am trying to run a VBScript that uses a SQL user to access a 2000 SQL SP4
clustered instance.
The script runs successfully only when I am logged on with a domain account.
What can the reason for this be?
Thanks in advance,
Ido Friedman... more >>
SQL 2005 Mirror - newbie question
Posted by Imran Vilcassim at 10/9/2006 1:07:02 AM
Hi,
when i setup mirroring between two databases, how does failover happen at
the client. if i setup a principal, a mirror and a witness, how does the
client redirect it self to the mirror server automatically?
would appreciate if someone could point me in the right direction.
regards... more >>
|