I do not think its the code.  I am testing sprocs with two completely different sets of code in two environments.  One on a SAN and one not.  This one...

I ran this in a test environment and was pretty isolated.  The box was not being slammed nor was it competing with other processes.

I believe brendthess is speaking of the production databases.  If you do not change the physical location of the databases they will be looking for the old location.  Both servers...

First I would check the properties for tempdb for this server.  If restricted growth is selected and the size is relatively small and you have a monster sqr or query...

This can be somewhat confusing when looking at sp_who in Query Analyzer.  I believe this is somewhat of an energy saver feature.  When a spid is sleeping it is simply...

You might want to check out KB169960. I had a similar problem and found that specifying a fill factor of 50 eliminated the deadlocking. This will spread out your...

I last upgraded PERC driver/firmware back in January. That might be something to consider. Nothing in event viewer logs. We are in the process of upgrading disk...

Unlike many DBAs I am constantly backing up and restoring backups on an almost daily basis. We are constantly shuffling Production down to our Conversion, Development and Test environments....

Thanks. I am considering Win2k sp4 now and have already applied ms03-039

I went through this fix on one machine a month or so back. I set the registry value to 10 on the first and did not add the second...

Yes. Windows sp2, SQL Server sp3

BACKUP failed to complete the command BACKUP LOG [FS8DEV] TO [FS8DEVlog] WITH NOINIT , NOUNLOAD , NAME = N'FS8DEV Log Backup...

I ran CHECKDB on all three databases. 0 errors. Ran backup to local disk immediately after and received same error. Backup to device fails as well. ...

This error is occuring on 3 separate development boxes. I find it hard to believe that each one has bad drives and controllers. Possible, not probable.

Nonrecoverable I/O error occured on file 'D:\MSSQL\Data\FS8CNV.mdf', BACKUP DATABASE is terminating abnormally. This is a conversion database that is constantly refreshed. This is a PeopleSoft database. PeopleSoft...