Just thought I'd give a bit of MS-reassurance to what Chris Musasizi (a.k.a. SSC-Enthusiastic) said. Unfortunately, he is totally correct. There doesn't appear to be any quick or...

Just thought I'd give a bit of MS-reassurance to what Chris Musasizi (a.k.a. SSC-Enthusiastic) said. Unfortunately, he is totally correct. There doesn't appear to be any quick or...

I guess it depends on how many hands are hitting the server.

In the situation where I would say it was acceptable is when others won't need to know...

Gail,

Good point and well taken.

That should probably go along with the best practices: keep an eye out to upcoming versions.

For those using pre-SQL 2008 servers, this would still be in...

Gail,

In response to your post, let me add that I believe a backup should be done in conjunction with the DUMP TRAN, when used. There are a number of...

Krishna,

I thought I'd post another alternative which I didn't see in your article. I've used this in the past, with good results. This method allows me to run...

FYI...it started working again. Nothing shows in the Event Log that seems like it could correlate...SQL logs didn't help either.

If anyone happens to know why this occurred,...