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...
March 4, 2011 at 8:57 am
Your output pattern doesn't seem to have a specific rule to it. Can you provide requirements for the output?
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...
March 3, 2011 at 9:02 am
Jpotucek (3/3/2011)
We lost Honey during the whelping of her...
March 3, 2011 at 8:56 am
Thanks for the update. I'm definitely looking forward to hearing the conclusion here. 🙂
March 2, 2011 at 9:02 am
Here is a great place to start - http://msftdbprodsamples.codeplex.com/%5B/url%5D
March 2, 2011 at 7:32 am
That is correct for NetApp.
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... 😀
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...
March 1, 2011 at 1:47 pm
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...
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...
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...
March 1, 2011 at 7:37 am
Viewing 15 posts - 256 through 270 (of 1,790 total)