Viewing 15 posts - 6,571 through 6,585 (of 9,244 total)
i log ship from a server in the UK to a server in USA with a time difference of 8 hours. As George says, what exactly is not working?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 11:55 am
ankur_libra (9/21/2011)
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE
timeout=30
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /sos /bootlog /noexecute=optout /fastdetect /PAE
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="HP SMP Preserved:Windows Server 2003, Enterprise" /sos /bootlog /noexecute=optout /fastdetect /PAE
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="HP SMP Preserved:Windows Server 2003, Enterprise" /noexecute=optout...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 10:27 am
forsqlserver (9/20/2011)
But stopping a sql service is a failover ?1.Why stopping a cluster service is not comes under failovers test?
2.May I know all the possible ways to test a failover.
At...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:45 am
Its all detailed in the link i sent you.
There are 3 possible quorum modes
Full Quorum.
This is where both partners and witness are connected
Witness to partner.
This is where the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:24 am
yes it's a lot of work. I did similar to this in my last contract. I had to rebuild all the cluster nodes one at a time and went through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:11 am
just out of interest why are you rebuilding, are you changing server collation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:28 am
check the cluster.log at the following location for more details
C:\Windows\cluster
or
C:\Winnt\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:25 am
Theres also an SSIS task to do this which works quite well
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:22 am
Which edition of Windows 2003 SP2 are you using?
Also, could you post the partition details from the boot.ini file on that server too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:21 am
vultar (9/20/2011)
2. uninstall clustered applications from node to be evicted
3. Evict node with command… cluster node <hostname> /evict
4. On node that was...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:17 am
is this a Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:07 am
the easiest way to test as NJ-DBA has already pointed out is to simulate a failure of the public NIC on the active node. Either pull the cable or disable...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:04 am
dbychen (9/19/2011)
Thanks Perry.Can MSDTC share a drive owned by the SQL Server or the Quorum drive? Does it require a dedicated drive?
As you know, you may now have multiple clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 3:43 am
how long do the log backups take to run, may be worth increasing the frequency further if possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 4:42 pm
rdavies 35008 (9/19/2011)
So even if the mirroring is paused, you still need to maintain quorum?
if you're running with a witness, yes
rdavies 35008 (9/19/2011)
I've clearly missunderstood the "Pause" function......
Its all detailed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 4:40 pm
Viewing 15 posts - 6,571 through 6,585 (of 9,244 total)