My PC has a measely 80GB while my wife and kids have 160GB and my in-laws have 100GB and a 40GB external storage drive. All on the same net. 

This system procedure works within the Select statement.  The syntax is:

select has_dbaccess ('database name')

Using the function by itself will produce a syntax error:

has_dbaccess ('database name')

What is the best way to control the size of the LDF?  Again, we're talking physical size here, not logical.  Physical size will fluctuate from 100MB to 5GB, but the...

AS, CS, etc.

These are various triggers set with the various collation types.  I am writing this at night, so I am sure you are well past the install process, however...

Thanks for the advice on this one folks!  I ended up generating the scripts for each and transferred them over per Olja's suggestion and it worked like a charm! (also...

Excellent -- thank you.

When you say "long running transactions" do you mean transactions that may still be running when the backup job is kicked off?

The db is indeed running in Full recovery mode.  Thanks for pointing me in that direction.  To have this ldf dumped automatically which mode...