Hi john.

Thanks for taking the time to respond.

Background:

The old server is a windows nt 4.0(1381) with a sqlserver database of 7.00.623. The application runs on the same server.

The application has...

I recommend SQL SERVER 2005 Administrators Pocket Consultant from Microsoft written by william R. stanek

It's a handy ..go to book

Hi Grasshopper:

The link you provided was great. it clear up the situation for me.

Thank you all for responding.

Hi scorpion

This is part of my problem. I remember something being mention in a newsletter but I can't find it. I do know it had was dealing with performance issues...

thanks for the info. However I have done all of the above.

There is nothing in the logs, I have comfirmed no other backups are running, and i get the feeling...