Viewing 15 posts - 6,586 through 6,600 (of 9,241 total)
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
bindview (9/18/2011)
The edition is sql server 2005 sp4. I will try your solution of creating the new backup folder and will post the results soon.Thanks for the help.
The network path...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2011 at 10:37 am
you should be able to get the IP address of the client this may help to narrow the user down
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2011 at 9:52 am
even better, slipstream the service pack for a trouble free installation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2011 at 2:33 pm
Viewing 15 posts - 6,586 through 6,600 (of 9,241 total)