Thanks for the correction.

-SQLBill

I agree that you have to get back control of your backups. How much disk space do you have? If you have room to do the backups to disk,...

I'll bet your backup is happening across the network. That's going to slow it down. If it's going straight to tape, that will slow it down even more....

Normally, my wife and I don't go away for the holiday. However, this year we are going to San Jose, Costa Rica with friends.

-SQLBill

25 connections to the database.

-SQLBill

So, as I asked....do you backup to disk and then to tape? Are you backing up across a network?

The best practice is to use SQL Server Backup commands (either...

I personally would add a third column and change the script so that NULLs showed up as Unknown.

Then if you have Unknowns, you can go back and further investigate them....

Just noticed you said you are using NetBackup.

Does that have a SQL Server agent? Or are you just backing up the .mdf/.ldf files? If you are just backing up those...

That's not a huge database, quite small in fact. I had a 300+ GB one in FULL recovery mode and it only took 4 hours to backup.

How are you...

Just for grins...go to Microsoft's website and download the latest MDAC version. See if that solves the problem.

-SQLBill

It looks like it's an error at the DB2 server. Maybe the connection times out before the query is complete?

-SQLBill

I'm not sure about the difference between Programming and Query as the book you saw used them. I would have to see the book.

However, it might be that programming involves...

For programming, I like Ken Henderson's The Guru's Guide to Transact-SQL.

For using Profiler, I like Brian Kelly's e-book Start to Finish Guide to SQL Server Performance Monitoring

Then there are the...

They had rations....no they didn't. The article said that the wife was NURSING the children because they had run out of food.

-SQLBill

There will be the armchair analysts who say he did the wrong thing leaving the car.....but he had two options:

1. stay with the car and his family

2. leave and try...