This will overwrite the backup every day. I suggest you look at our scripts section and get a script that will change the name of the file everyday used for...

copy only backup?

The mirror log files should not be growing. Are they still growing?

I'm a part owner of SQL Share (www.sqlshare.com), and we have had good reviews. You can contract for onsite, or attend a class.

In addition, make an attempt to join the tables together in a query.

We are happy to help, but we should not be doing all the work for you.

Thanks for the update. Everything in the database moves with the backup, though your users might not be linked back to logins.

Use the WITH INIT in the backup command, or don't check "append" in a maintenance plan. You typically then have the files named differently each day. There are lots of...

Does this not work in SQL 2005?

It's old style SQL, not ANSI, so you ought to rewrite it.

Instead of listing each table and then having a comma you would want...

Here you go: http://www.iana.org/assignments/port-numbers

Typically I use something above 50,000 to avoid conflicts.

I think I interviewed Derek one time.

Nice one!

I don't know what conclusions to draw, or how widely to take the ideas. Some of those ideas have been implemented at Red Gate, and I'm not sure how they're...

That sounds like a good plan then. I'd give it a shot, short term, test the DR, and post back. Or write up your experiences. I'm sure people would be...

One thing to be wary of with remote storage is that SQL doesn't know things are committed, and you could end up with an inconsistent database, especially if the transfer...

It sounds like you've thought it through. Assuming Amazon gives you good bandwidth and enough horsepower for the VMs, you ought to be fine.

The transfer is the only thing I'd...

The question is what's the right level of taxation, for what benefits. Reagan's administration (correctly) surmised that lowering the top tax rates from above 50% to below 50% would...