you can try this:

1) Look through the startup section in the SQL error log for the named instance and note down the port no

from the section which mentions the...

Indeed useful, Thanks for sharing.

ok try running sp_updatestats as well if you have not done that already.

sp_updatestats is relatively lighweight because:

1) it only uses default sampling.

2) and it only updates statistics for tables ...

Thanks for providing this useful information.

The information from the following URL may provide some help.

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/34ab68ad-706d-43c4-8def-38c09e3bfc3b/

From the error message it looks like the problem may have occurred possibly due to temporary unavailability of the backup media.

you may be able to find additional information in the...

ok this is really interesting, how does a backup database command get associated with a backup database operation? I mean how does a transaction come in to the picture...

maybe you can try running try following command:

select * from sysprocesses where spid > 50 and status <> 'running'

spid> 50 will filter out all SQL Server system processes...

I think the general rule of the thumb is that rebuild of a clustered index requires 1.5 times the actual size.

As mentioned in an earlier reply you can use TempDB...

First of all this is a significant change considering that a whole lot has changed from SQL 2000 to SQL 2008.

Therefore the first thing that you would want to...

By any chance did you see the following message in the SQL error log?

"A significant part of sql server memory has been paged out. This may result in performance degradation."...

Adding my 2 cents as well.

I would like to reemphasize as to what has already been mentioned regarding moving of system database.

The benefits (if any) would not outweigh...

and the following URL( and associated hyperlinks) will help you in your quest for obtaining information that you are looking for:

http://technet.microsoft.com/en-us/library/ms190699(v=sql.105)

and if I may add,stay away from services.msc if you are working with clustered SQL instances.

I am still a long way from understanding a deadlock and all related aspects very well and therefore a post related to this topic is very helpful in this regard....