I think Steve was paraphrasing Fred Brooks: Adding more people to a late project makes it later.

The reasons above are pretty accurate and the classic example is 9 woman cannot...

I use yyyymmdd for filenames. Easier to sort things

I think the dd-mmm-yyyy where mmm is Jan, Feb, etc. makes sense.

As of now, we're...

Yep, I'll add it to the list. This whole section will get some work in the next couple months.

Very strange. Does it hang when scheduled? I'm assuming that's the issue.

Are you sure there's nothing else in the package that would pop a msgbox or wait for some interactive...

It is a nice clue that the author may not be the brightest T-SQL bulb in the pack, however.

It's an interesting question, and one designed, IMHO, to see how you think. Proving a negative is always hard and to me the question doesn't make much sense without more...

Try this

declare @val varchar(200)

exec xp_regread @root_key = 'HKEY_LOCAL_MACHINE'

, @key = 'SYSTEM\ControlSet001\Services\MSSQLServer'

, @valuename = 'ObjectName'

, @value = @val output

select @val

Might have to alter for your server.

You should be able to fire off a task from the Service Applet. After xx failures, send an SMS message or email to yourself from there. Is this W2K3?

I've tried Excel, Outlook, and Project to do this and it was a mess everytime. The biggest reason was the granularity of minutes for jobs instead of hours or days...

Be sure you change the filenames. By default it has the file names for the existing db. In the EM dialog, change the db name manually after picking the backup...

How many connections are we talking about? They all use a small amount of memory, but it would have to be thousands and thousands to crash SQL.

You might try some...

John has great advice. It makes sense to do optmization and integrity checks first so if there are issues, then you can get an alert and be ready to fix...

OK, bad question. Also, ping MS on the documentation to change it.

Points awarded back.

That's interesting as well. The developers are working on the basics now, but I'll definitely ask they watch this thread.

STeve

Yeah, some of the nav is buggy. We're on a rewrite as I, well, write this, using the newest version of the forum software.

Apologies