We have at least ten or more VMware machines with no issues , other than performance once in a while. We are running SQL2K SP3A.

I would defintely make sure the transaction log dumps do NOT occur durring database backup times as this will cause problems.

[when i look at the properties it says that...

That would contain the database name if the database name was being passed to this command through a variable. Is the only reason you wish to dump the log is...

We run an Enterprise Scheduler and we want to place backups in the jobs prior to and after updating in some cases. By scripting backups, reindexing, etc., we can control the...

Inserts, updates, deletes and DDL changes. Also, need to be able to track if the tracking services have been shut down at any time or the auditing configuration has been...

Adam, IF you open Enterprise Manager, right click on the server, click on Properties, then click on the Securities Tab, this should show you what mode you are running in....

Here are a couple -

For SQLServer 200 - SQL Server 200 Fast Answers for DBAs and Developers

    Joseph Sack - Curlingstone Publishing http://www.curlingstone.com

Inside SQL Server 200

  Kalen Delany...

When you add the group, what are you loggin in with? Grooup name or your user id?

Yes, you can do a backup from the command line. But I would agree that maybe you should look into why the maint plan will not run. Check to see...

Jeremy, good job on the article! The "2 AM" test is the highest of all tests!! If it passes, it must be good!!!

I have found similar results, as athurgar has, using scripts instead of the maint wizzard. I would strongly recommend you try the same.

I don't see any either. For checking growth patterns, you can always look at backup sizes to monitor growth patterns.

See BOL - Orphaned Sessions - KeepAliveTime. I think this may be what you are talking about.

Jason, that is my understanding. When the log file is restored, the comitted transactions a rolled forward (reading the log file) and the uncomitted are rolled back.

Also check to see if you auto shrink set on on the database. Sometimes these settings can cause performance problems.