Search for sp_delete_backuphistory stored procedure under books online and you will get your answer regarding backup tables pruning.

MJ

Is their any error message in error log?

MJ

Once first and second step is completed apply SP4 from the active node with both nodes online and choose only node 2 under the server selection option tht appears while...

You need to monitor both the counters during the same time period. Also, we need to know total memory on box, memory set aside for sql server.

MJ

Is SQL Server getting rebootedd at that time?

MJ

Create one stored procedure and encapsulate the code in it. Use xp_sendmail for sending out mails.

MJ

Any error in Windows event viewer logs?

MJ

Don't you get "launch database mirroring monitor" option when you right click any database?

MJ

Try this:

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (http://challa.info)

and the database Roles that the user belongs to in all the databases.

Also, you can use this...

You can reset the latch and waiit stats counters.

DBCC SQLPERF

(

[ LOGSPACE ]

|

[ "sys.dm_os_latch_stats"...

Have you tried logging onto windows interactively using the domain ID generating error messages in log?

MJ

Try the below mentioned modified code provided by Paresh:

IF OBJECT_ID('USP_ExecReorgRebuildIndex', 'P') IS NOT NULL

DROP PROCEDURE dbo.USP_ExecReorgRebuildIndex

GO

CREATE PROCEDURE dbo.USP_ExecReorgRebuildIndex

(@Exec AS INT,

@Print AS INT,

@Threshold AS INT)

AS BEGIN

/*

Parameters:

...

Are you making use of log file under the job? If yes, whats the complete error message in it?

MJ

Have you tried the steps mentioned in -->http://www.tech-archive.net/pdf/Archive/Win2000/microsoft.public.win2000.registry/2004-09/0278.pdf

MJ

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Adding A Logical Disk To Your Cluster Configuration

Because dynamic disks are not supported in Windows Clustering, adding a disk to the configuration at some point after the initial configuration will...