Viewing 15 posts - 1 through 15 (of 59 total)
I'm experiencing the same problem on SQL 2008. When I move to a new server, I always backup master and msdb on the old server and restore it onto the...
June 29, 2010 at 7:36 am
Our whole database team struggles with this problem. We all ended up having to add the subscriptions with the GUI. I figured out how to get a script to work,...
June 14, 2010 at 2:16 pm
Thanks Pam for the response. What are you distribution and log reader agent profile parameters?
December 30, 2009 at 7:24 am
What errors are you getting?
December 29, 2009 at 2:01 pm
Just need a tad more information. Is the Distribution Cleanup job which deletes from MSRepl_commands table blocking the log reader(s)? or is each log reader blocking each other?
December 29, 2009 at 1:59 pm
Wow. No guru's wanted to tackle this one eh? That's why our motto here is:
Replication...
...just say no.
Lezza
June 16, 2009 at 8:52 am
Well yesterday that MSrepl_commands table had a scan density of 39%. After a index rebuild and half a night of deletes, it has a scan density of 59% and avg...
May 14, 2009 at 6:50 am
Some great suggestions David! BTW - I guess I should have mentioned that we're having I/O issues on this server which is why it's taking the DELETE process so long....
May 13, 2009 at 10:18 am
The process that is having the CXPacket problem is a SELECT statement with a hideous Where Clause. I'm not particularly sure that this is what's taking up all the CPU,...
January 12, 2009 at 11:51 am
Got a little more information. Not sure if it has anything to do with it..
The packages that are failing were packages which the developer "modified" with his client tools...
December 30, 2008 at 9:25 am
Finally found it by accident after I'd looked for it all morning. Just in case someone else can't find it:
TEXTIMAGE_ON on the CREATE TABLE page.
August 13, 2008 at 11:11 am
I think there's a company in Tulsa, Oklahoma that is planning to offer a SQL Server University type thing where you apply and if you are selected for the class,...
August 8, 2008 at 7:14 pm
Ever consider a remote DBA service rather than carrying the cost of an employee? Our company can give you access to top notch SQL Server DBA experience for pennies on...
August 8, 2008 at 6:52 pm
Ahh... got it. Opened the wrong window, and didn't notice. I should have opened the actual Schema dialog box and reassigned the ownership. I was opening the dialog box that...
June 1, 2007 at 2:57 pm
Viewing 15 posts - 1 through 15 (of 59 total)