Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at http://ask.sqlservercentral.com. Not my idea, and I'm not sure how we'll sync up points/rating...

You can run in simple mode, but you cannot recover to a point in time other than your full backups. If that's important, then you do need to be sure...

The only thing I might add is be sure the backups (data and log) are going to drives separate from where you data (mdf/ndf) files are. If something happens to...

Does this help:

http://msdn.microsoft.com/en-us/library/bb326385.aspx

http://msdn.microsoft.com/en-us/library/bb326385.aspx

you might want to read this: http://www.sqlservercentral.com/articles/64582/

Are you pointing to a remote drive? I'm not sure you can do that in the maint plan, or that you want to do this. If there's any network hiccup,...

I'm not sure that people think being paid average wages is being used. There are plenty of people that would like to make more money, but feel they get paid...

This sounds either like a bug, an obscure one, or someone has seriously screwed with permissions in your system.

Do you have an MSDN or TechNet subscription? I might burn a...

I've altered the question to say SQL 2005. However varchar(max) wasn't available before that version. We typically don't make up functions in the questions, only the answers 😉

I was at Arlington this summer, took my son, visited a friend. Section 59, plot 1192. It is indeed sobering.

You can use system monitor for this. Or search for baselining your SQL Server.

I think Grant meant "Hammer. That's the answer. A good hammer will fixnish or ...

I think it's similar, but it seemed to be more like a high powered SSIS or cube calculation system. Handle lots of aggregations in a short period of time. I'll...

My 10 yr old fired a 12g shotgun a couple weeks ago for the first time. Hit 2/5 clay pigeons. I was impressed.

That's rather strange. Does this occur with any other users on other machines in your domain? Is the job a target server job?