Those are still syntax errors. They say that the variable hasn't been declared. Somewhere either the declaration is wrong or the use of the variable has the name typed incorrectly.

Those are syntax errors. You have mistyped something.

Hmm, this thread like cat litter....maybe I can get an analogy there.

Actually this thread provides me with alternating periods of confusion, information, and entertainment.

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...