I'm saying that's one option, yes.

John

Not as far as I know. But you could manually amend the script as soon as it's generated. Or you could write your own query to return an...

I've never heard of it, but from its name, I'd guess that it's a trigger on the sysarticles table in your published database. Does such a trigger exist? ...

Is that because you haven't changed anything? Try disabling replication and pressing OK, then open it again, tick the box to enable, and see whether the Script button is...

I don't know what's going on, but one thing that may be worth trying is instead of hitting OK, generate a script and run that, one statement at a time....

Mike

The log backup will only be huge if you haven't backed it up for a long time (or, more accurately, if there has been a lot of changes in the...

Mike

Yes, your understanding is correct. That's (one of the reasons) why it's important to make regular transaction log backups. DBCC SHRINKFILE is indeed not recommended for regular use,...

It works on SQL Server 2012. Make sure you choose Surface Area Configuration from the Facet drop-down list in the View Facets window.

John

I think you'd be better off with an alert that notifies you every time there's a blocked process event (if that's actually what you want - you may change your...

I notice this is an old thread, but in case anyone reading it is in a similar position, the steps are much simpler than those recommended above:

(1) Take a transaction...

Yes, good point - Microsoft released a fix prior to SP3 that's supposed to have addressed stuff like this.

The only things I can recommend are updating statistics more often (with...

Koen, I'm not sure we've enough evidence yet to prove this is a bug. It could just be that a different execution plan was compiled after the restart. ...

Did you update your statistics after applying the service pack?

John

No, not quite. That location will only apply to the database specified in the General tab of the Back Up Database Task. If you're backing up all databases...

It sounds as if it should work. We're reaching the edge of my knowledge of this, I'm afraid. Did you run the command I posted earlier just to...