Viewing 15 posts - 12,256 through 12,270 (of 39,963 total)
You may have the active portion of the log at the end of the file, which prevents it from shrinking. One of the things you can do is run some...
July 18, 2013 at 9:25 am
You might also track some of the existing waits with regards to IO. http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
July 18, 2013 at 9:24 am
I suspect you had someone setting this up that didn't understand RPO/RTO and was just managing the log size, not worrying about recovery.
I'd make the logs more frequent.
July 18, 2013 at 9:23 am
LEFT, SUBSTRING, you need to limit the amount of data updated, as Eugene noted.
July 18, 2013 at 9:21 am
Have you setup clustering? If not, you might want to hire someone as a consultant to help you here.
It's unclear what you are trying to accomplish with a cluster. You...
July 18, 2013 at 9:19 am
Brandie Tarvin (7/17/2013)
I see a SQL Spackle article in my future... Plus a blog post followup.
Write it up and send it in
July 17, 2013 at 12:01 pm
Koen Verbeeck (7/17/2013)
Jeff Moden (7/16/2013)
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.BWAAA-HAAA!!!! You mean like the stuff that generates the SSC News Letter? :sick::-D:-P
Touché 😀
Yeah, that's been...
July 17, 2013 at 7:52 am
Most days software works flawlessly for me. I have a small domain of things I do, and they work great.
The last two days I've expanded into the continuous integration world,...
July 16, 2013 at 3:56 pm
Arrgggg, some days I hate software.
July 16, 2013 at 1:21 pm
Ellen-477471 (7/16/2013)
that when...
July 16, 2013 at 9:03 am
Revenant (7/16/2013)
Steve Jones - SSC Editor (7/12/2013)
Essentially on the source you:
- create master key (protected by SMK) in master.
- create cert, protected by DMK (master key).
-...
July 16, 2013 at 8:58 am
The first shot was fired.
That's about all we can say. Anything else is guesswork, hearsay, and likely self-serving.
As Jeff said, we're all in this together. Devs and DBAs need...
July 15, 2013 at 1:13 pm
thanks for the update. Any resolution steps others could try?
July 15, 2013 at 1:11 pm
BTW, an interesting read here: http://stratechery.com/2013/why-microsofts-reorganization-is-a-bad-idea/
July 15, 2013 at 9:39 am
dg81328 (7/14/2013)
1) they do this every few years
2) it does not change the patterns that...
July 15, 2013 at 9:39 am
Viewing 15 posts - 12,256 through 12,270 (of 39,963 total)