Again, thanks for the help. I had a version problem, it complained about the OS ver and I went down the wrong path.

Thanks for the help. Pretty sure now it is the version of Sql and the OS I'm trying to use instead of 32 bit on x64 bit OS.

David

Good stuff guys, I'm going to make this part of our standard server build.

Probably add an exec sp_readerrorlog after the fixed driver proc.

Mani

There have been a couple of good suggestions posted on possible causes of your problem. However, I think it is a problem in the code and needs to...

If msdb isn't in sysdatabases, Sql Agent wouldn't run and the job wouldn't fire and allow the other 2 system databases to be backed up.

The problem is mostly like in...

The Quick fix just add a step that does a backup command:

backup database msdb to disk='your_file_path_here' with init;

To continue troubleshooting the code I would added print statements to see what...

Joe

I don't believe he is trying what you are describing. The way I'm reading the post Mani has common code for a common job deployed to multiple instances. ...

Mani

You need to check the Sql Server error log not just the job log. Run the job and then run:

exec sp_readerrorlog;

I'm expecting some kind of error at the time...

What does the the log say from the instance that is failing to backup? Does the E: have enough space to backup msdb? If you have...

I've just looked at the four main tools in this software market. IMHO Sql DM from Idera is the best. Performance Advisor from Sql Sentry is the...

I think the article should have had more technical content or been labeled an editorial. I didn't learn much from it.

They process probably died while it was waiting for the file to grow. It probably just came down to disk contention.

If you only get 1 9002 message my guess is the transaction is failing on the full log and rolled back. Typically in Sql2k if the tempdb log fills...

Once you get your formatting issues fixed the function is datediff. Check out Books on line for the details of the function.

If the kill\rollback spid is not using cpu or disk between executions of sp_who2 it is a ghost process. The rollback was done long again ago. ...