Hey Listers,
Does anyone have any tips for maintaining transaction logs
in SQL Server? Ours seem to growing at an insane rate and nothing our DBAs
are doing is helping at all. And I'm continually getting time outs when
trying to save workflow. And that is without any users. There is nothing
special setup in development and I can do a backup, truncating the logs and
that helps for a while. In production, however, we have log mirroring setup
for DR purposes. It's killing me. The DB and AR box are both on their own
dual quad core servers with 4GB RAM, so I don't think it's a resource issue.
Any advice is appreciated.
Thanks!
Brian
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
