First Check for any open transactions in Tempdb by running below query.

DBCC OPENTRAN

if you get below results means,start to shrink the Tempdb files.

dbcc opentran

--No active open transactions.

--DBCC execution completed. If...

Hi,

Check cluster.log in the cluster installation path and based on the failover message log,set your monitor.

Thanks

Kumar

http://sqldbataskwithkumar.blogspot.com

Hi ,

Go to Enterprise manager->Right Click SQL server Group->Fill All details

Then Register SQL server by expand SQL server Group and choose New sql server registration.

Fill with sql authenticated credentails.

thats's...

How to view dtspackage error log in a table?

select * from msdb..sysdtssteplog order by endtime desc

select * from msdb..sysdtstasklog order by endtime desc

select * from msdb..sysdtspackagelog order by logdate...