Hello CrazyMan,

Do not crazy about SPID 1,2,3...

I mean do not worry about 1 to 50 SPID it's exclusively used by internal system. You should worry about 51 onwards SPID.

Good Day!

I am agreed with Gail.

It looks like performance issue. Try to find more detail finding in the errorlog.

Also perform test to find out any hardware & software bottlenack. BE CAREFUL...

I guess Method 1 should be fine.

You can shut down SQL Server 2005 failover cluster. Already your instance is running on the other server. When you will restart server it will work.

Depends: Why you need...

Try to find more detail in event viewr which will hep you to narrow down the issue. Also restart the box or uninstall and reinstall the .net framework. Do not...

You can see the log by using following command:

SELECT * FROM msdb.dbo.sysmail_event_log

See the mail has been delivered by SQL Database Mail on time? Probably you can take it from here.

Another reasons to grow your Tlog is if your Mirroring is not working properly(i.e. latency is more) or if Mirroring is pending on destination DB it won't truncate the log.

Check...

Hello Shree,

Though your db backup size is 6 GB it is quite possible that after restore it will grow upto 27 GB.

Find following things:

1. Check source db data and log...

YOu can think about following third party tool or similar tool:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Do users are having any blocking problem?

You can use sp_lock to check the lock info.

Hello,

This is very wide questions.

All depend on the how application is as well as the size of the database?

What kind of query generally user will use read or write...

Hi Jackal,

have a look at following gif file it's exchange-cluster but similar way we can have sql cluster.

http://www.progent.com/images/exchange-cluster-1.gif

Also following link will help you to understand more:

http://www.eggheadcafe.com/forumarchives/SQLServerserver/Aug2005/post23633739.asp

http://sql-server-performance.com/Community/forums/t/17436.aspx

Hope this will help.

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

If performance is not a problem and by hook or crook you would like...

You should not worry about the Data. DBCC Shrinkfile never deletes any data.

It will shrink datafile to specific size which you have mention during the DBCC Shrinkfile command.