My shop is skipping 2005 and going straight 2008 but I intend to keep the same configuration.

No I didn't have a article or recommendation. The dyanmic port keep colliding with other apps (as described in the article you quote) and caused down time.

I selected that...

My shop has had problems with dynamic port assignment and binding in Sql 2000. Port conflicts can happen but you'll still be able to connect using Query analyzer...

Madhu

My advice is to become more familiar with your errorlog. All of your backups (log, differential and full) are recorded there. Additionally, the log entries in my previous...

I agree with Phil's recommendations although I haven't had time to review the code but a quick scan says it is something I'd change.

The log tells me your getting nightly...

I suspect your backups are not running the way you think they are. To aid you further ,I need the results of this script:

exec sp_helpdb 'your db name...

Is that share local to the server your running the backup on?

If so please post the log file for the last few days and the exact backup command you running....

What version of Sql Server are you using? Has this job run successfully before?

Your backing up over a admin share (D$) so I would verify the security permissions although...

Found it!!!

Our freight calculation (delphi code) is doing a delete-insert every time freight is re-calculated. Freight has a item_number and we have three indexes that have the item...

Gail

Thanks for the insight. I hadn't thought of that at all. I think I'm guilty of over-engineer my joins in an effort to address the previous deadlock issue....

Ok, now that Gail has taught me how to post. 🙂

The attached file shows the statement level trace for the two deadlocking spids plus the deadlock collision from the...

The transaction log will not auto shrink. It sounds like you have a maintenance job or plan tha that is running overnight. I would investigate that as...

Gail

So that is what the attachment button is for:D;)

Amazing what you learn when you scroll down. :w00t:

Sound like share security isn't right.

Verify that the account the Sql Agent is running under has explicted permissions on the share.

Matt

I love the phrase "institutional sloppiness". I've officially stealing that from you.

David