Viewing 15 posts - 6,586 through 6,600 (of 9,244 total)
rdavies 35008 (9/19/2011)
the principal database shouldn't have gone offline when I broke the comms link (by shutting down the Firewall)?
Yes it should, because you wiped out the witness too which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:32 pm
yes, if you want to take the mirror down for a maintenance op or some other business reason then this is what the pause is for. If you plan to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:14 pm
Right, but v 10.00.4035 is post SP2 10.00.4000 so you wont be able to apply SP2. 4035 must be a hotfix release level
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:02 pm
Books Online
If all the server instances become disconnected from each other, the session is said to have lost quorum. As server instances reconnect to each other,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 2:55 pm
check this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 2:47 pm
If you know you're taking both down, remove the witness first then pause the mirror.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 2:41 pm
Preventative maintenance?
Out of interest how often do you run transaction log backups?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 2:18 pm
in synchronous mode with a witness the loss of the mirror partner and the witness will take the principal database offline.
Why did you pause the mirror if you were taking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 2:11 pm
check for further info in the cluster.log
This is located in C:\Windows\Cluster or C:\Winnt\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 10:17 am
SQL Server compression is indeed favourable when compared to 3rd party products such as Litespeed or SQLBackup. The big issue for me is that when enabling TDE compression is void....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:57 am
Amu (6/1/2011)
Trasaction log backup will allow you to recover to point in time of the failure while incremental backup won't.
In BULK_LOGGED recovery model this is not necessarily true and shouldnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:46 am
Jeff Moden (9/18/2011)
Thanks, Perry. I feel extremely lucky, deeply humbled, and honored all at the same time.
Trust me buddy luck has nothing to do with it. IMHO you were...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:36 am
who are you logged onto the machine as?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:32 am
No problem, thanks for the update
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 12:22 am
Jeff Moden (9/18/2011)
This is just so wrong... What is the name of the school where they are teaching you to do such a thing in SQL Server?
RBARs R Us 😀
BTW,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2011 at 1:35 pm
Viewing 15 posts - 6,586 through 6,600 (of 9,244 total)