You'll have to get the 2005 media from somewhere. The "downgrade" is merely a "right" that the license has. You can buy a 2008 license and apply it to a...

If Sharepoint uses a post SQL 2005 client, a SNAC client, you put both addresses in the connection string.

http://www.mssqltips.com/tip.asp?tip=1289

You need to look in the maintenance plan and be sure this database log is being backed up.

It's entirely possible that your log needs to be bigger. If you are changing lots of data (as opposed to adding it), the transaction load could be high.

My guess is...

You did overthink it. PBM executes basic SQL against all editions. Many of the policy checks in 2008 are SQL as well, so they are the same checks. The things...

Really you need to check any errors. Lots of information things can get put into the log, but any error needs to be investigated.

The resolution will vary widely depending on...

Autogrow ought to be turned on. You don't want your database failing because you can't respond or you're asleep.

However, you want to grow in large chunks, and minimize growths as...

Here's the basic idea. You can get a backup to work, unless you are saying that you can't get a log backup made, copied, and restore in your window.

what you...

You can use the ALTER DATABASE command or right click the database, choose properties, change the file sizes.

I guess that Twitter SQL help thing is going to work out great, isn't it?

There likely will be some issues, DNS caching, client caching, ARP/network issues.

Put your new server up as a new name for DR. You can rename it in the event...

I agree with Jeff, you need to test. It could go either way.

Make sure you test different situations and a variety of possible parameters.

checking for a trigger is a good idea.

Have you tried to create other logins? Used other names?

It's a good idea, though honestly I'd apply to any regular DBA jobs you see, note what experience you have and that you are willing to learn. I might also...

Let us know what happens.

CALs are still there, but for internal users. If you're going for anon users (Internet), you need the CPU.