From my post I meant that it would make sense for the DBCC to come back clean after a reboot as the SQL restart (server crash) would have cleared the...

Could be an issue with the DBCC snapshot.. the only thing I could remember was this post a while ago:

http://www.sqlservercentral.com/Forums/Topic450261-146-2.aspx#bm477512

Would make sense if your DBCC came back after...

As always I would suggest backups before any work is carried out but it should be ok to drop the index and recreate, you will have to perform an offline...

Could be a section of the LDF file that is corrupt, does DBCC CHECKDB return any errors? Below is a link which could be of help to you.

Was the TempDB data file on that drive? A restart of SQL Server will rebuild the temp database so could have released space that way. Could also be an ldf...

Edit: Someone else posted the solution before me.

From the error posted looks like you have .ldf files for tempdb, msdb and BizTalkMsgBozDB. Is the drive which held these files still online?

Got backups off those databases?

The tempdb...

I would also be concerned with the 'The transaction log for database 'Maximum' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column...

Here is a link to what the error means:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/

Means that you are missing SSIS from the install. Can you check if that's the problem and let us know.

Well if the IP/FQDN doesn't resolve the issue can you confirm that the database was restored with the NO RECOVERY option on the secondary? Also run a select from sys.database_mirroring_endpoints...

Well first thing I would suggest is run checkdb manually just to make sure there is no corruption. If all is well (hope so!) open the job in SQL Agent,...

First double check that both servers are up and can see each other, next check on both nodes that tcp/ip and named pipes are enabled.

The link below goes into details about the diffrences..

http://dotnetyuppie.com/2008/01/03/simple-sql-performance-monitoring-with-sp_who-and-sp_who2/

Ah that's the post I was looking for, did look on Pauls website for that link.

Hi,

The extra CPU usage is around 5% - 10% overall I believe. Paul Randal did a blog on the performance impact of turning on Checksum from torn pages.