Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
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 >>



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 >>


DevelopmentNow Blog