If Windows 2003, You can also use FORFILES to delete your files, type FORFILES /? at cmd prompt for more info.

Delete backup copies older than 2 days

Use Operating System(CmdExec)

FORFILES /P...

Backup, Log Shipping won't work for downgrade.

Use replication, Snapshot works in your case.

Don't think that virtualization is recommended for Prod.

We use VMware for Dev & Staging.

-- 2005 GUI,PDR etc give great info, 2008 is even cooler, gives info on SSMS object details only

-- For 2000

use databasename

go

select

[FileSizeMB] =

...

That link is for adding or removing nodes in SQL 2008 Cluster.

--

All cluster nodes that I have worked on had single sql server instances. Has anyone added another instance in...

Anyone?

Check out the whitepaper.

Run the profiler from your local computer only not from the server.

When you ran a SQL Profiler trace by using RDP on the server itsself, the tmp files are stored...

Why are you using Without Automatic Failover?

Wouldn't using With Automatic Failover give you high availability.

How about using Maintenance Plans for doing backups?

Before you think about triggers,sps, think about using Constraints like Check & all, Get more info from BOL.

How about using backup & restore to refresh dev, Don't know much about 7.0, does that work?

Any plans for upgrade?

if 2005, Have you tried TableDiff.exe?

Open a case with MS.

You can try a few steps, in simple recovery model the t-log automatically truncates after each checkpoint, this tells me that your disk space is not sufficent, should try getting...