Viewing 15 posts - 256 through 270 (of 1,790 total)
Unfortunately you are going to lose any out of sync transactions based on the state you are in. What you will need to do is stop the logreader agent for...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 4, 2011 at 8:57 am
Got it. Thinking.... 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 3, 2011 at 4:02 pm
Your output pattern doesn't seem to have a specific rule to it. Can you provide requirements for the output?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 3, 2011 at 3:50 pm
Well, that is definitely odd.... 🙂 Glad that you fixed it though.
Out of curiosity was there a system process from the backup agent running when the instance was failed...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 3, 2011 at 9:02 am
Jpotucek (3/3/2011)
We lost Honey during the whelping of her...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 3, 2011 at 8:56 am
Thanks for the update. I'm definitely looking forward to hearing the conclusion here. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 2, 2011 at 9:02 am
Here is a great place to start - http://msftdbprodsamples.codeplex.com/%5B/url%5D
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 2, 2011 at 7:32 am
That is correct for NetApp.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 2:24 pm
Grant Fritchey (3/1/2011)
Well do you want video or just pictures?
Just don't put either on The Thread. Please... 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 2:14 pm
homebrew01 (3/1/2011)
On my current system, the LUNs are "horizontal" so that LUN1 takes a slice of all drives, as does LUN2, so there's no real benefit to splitting things up...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 1:47 pm
Ninja's_RGR'us (3/1/2011)
David Benoit (3/1/2011)
SKYBVI (3/1/2011)
The question should clearly tell that there are MULTIPLE ANSWERS..Regards,
Sushant
Agreed. I would have chosen more than one but since it didn't say that I chose only...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 9:39 am
SKYBVI (3/1/2011)
The question should clearly tell that there are MULTIPLE ANSWERS..Regards,
Sushant
Agreed. I would have chosen more than one but since it didn't say that I chose only the one that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 9:33 am
lilywhites (3/1/2011)
i have kind of resigned myself to restarting the instance as soon as possible....looks like that will be tomorrow night now
i will update you all to let you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 8:23 am
My guess is that you will have to kill the instance to clear it if you stopped the backup agent service and you still have the thread open. I had...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 8:00 am
TheSQLGuru (3/1/2011)
1) sp_whoisactive2) search web for glenn berry sql server DMV. here is one for 2008, he has another for 2005. lots of goodness here: http://sqlserverperformance.wordpress.com/2009/05/21/sql-server-2008-diagnostic-script/
...and to go...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 7:37 am
Viewing 15 posts - 256 through 270 (of 1,790 total)