I noticed this in my log file:

"Msg 6107, Sev 14, State 1, Line 1 : Only user processes can be killed."

So there's some system process every once in a while...

I am using RedGate Backup/restore, and have included DISCONNECT_EXISTING, but it does not always work.

My primary concern is reliability of the restore process, with speed secondary.

"The simplest way to send out the email on the failure of the data flow, is to add an email task in the control flow. Connect it to the data...

mataleao87 (5/30/2015)

That was it. Have many more new issues but seems like some progress...

I think it's the folder permission you need to check, not the files within the folder.

Thanks. Currently I'm working with a mix of 2005 & 2008 servers, so extended events won't work on 2005 (I think).

I'll read up on it for the 2008 servers, as...

Could you elaborate on "Extended events work much better." ??

I came across this bug earlier today and did fix the code. But I was puzzled about why it failed.

I hadn't really though about this:

" the case statement can only...

Thanks for all the feedback.

TORN PAGE is on.

Select * from msdb.dbo.suspect_pages gives 0 results

I have not run CHECKDB for a long time, until the results posted above.

I can run it from a scheduled job without problem, and I can run it manually from a query window without a problem. But when the web application is...

Does anyone have any ideas of how I can troubleshoot this ?

Is there some other error trapping I can do to get a better explanation or more useful error messages...

Can you take a Differential ? If so, at least you will have some protection with the Full that did work, plus a new diff. If it...

Server is running SQL 2005, so please post any replies in a new thread I created in the 2005 forum:

http://www.sqlservercentral.com/Forums/Topic1656437-146-1.aspx

In my recent case, OPENQUERY is better because when...