I am sure you do, but just for the sake of asking:

how frequent are your backups?

Correct..

I Just tried to match his Query..

But arent the roles self explanatory by their names.

I think Yes, you can do that. But Be careful of max memory in each instance.

Well Guys read this to know more about your RAID requirements:

http://sqlblog.com/blogs/linchi_shea/archive/2007/02/07/is-raid-5-really-that-bad.aspx

check for errors [SQL Server], database engine in BOL and you can get a Error Number or something to setup the alerts..

What is the RECOVERY MODe of your database. is it FULL/SIMPLE/BULKLOGGED.

What is the Size of your transaction LOG.

These Things will affect the RESTORE Process.

Nothing to worry about sleeping sessions.. Just Keep an eye on the Blocked Sessions and status='runnable'

Again, IIS uses connection pooling right?, so there should be no issues... but in certain...

As Gail suggested.. see if you can get another HDD.

Else always keep them seprate from OS Drive.. Anywways.. what is the size of each drives and how much free space...

The Resource Database depends on teh master Database.. Check the Link.. it has more info, then i can share here with you...

So keep master and resource DB's Together.. whereever...

It Does that the First Time on such a big DATABASE. I had a 79 GB Db and it took me.. approx 4 Hrs to restore.. after that it seems...

Good Post.. Service Broker has that issue or a Behaviour, and can increase the size of your msdb...

select * from sys.server_principals

WHERE TYPE='R'

Description.. I am not sure SQL Server has any description associated... in any tables.. get that from Books Online...

Yes you can move the master/tempdb/model/msdb to diff drives. but do not try to move the resource database.

Again, leave the resource and master Databases at the same location. they both...

delete from a where a.column in (select b.column from b where a.column = b.column)