Absolutely, time for lunch. Right after I put my daughter to bed.

There's still some v65 and v7 servers out there running fine.

Gus,

Don't forget plenty of third party products, like SQL Backup, can give you compression, at a substantial savings over upgrading.

Good points on the tail wagging the dog, and I'd forgotten service packs can extend out support. I'm not sure you'll get a GDR for your SQL Server 2000 SP4...

I'd call MS support. Not sure anyone else can help you here.

Moved to SQL 2000.

It builds a package in Integration Services. You can save it and then open it up in BIDS.

What do you mean by getting killed?

Have you benchmarked? Any counters changed? Possible workload changes?

21GB might take some time to run up to 44GB. Can you run some larger queries...

datecreated on installation folder? (/binn)

I might also be sure that the spacing is there. If you might have more than one space, I'd consider using charindex/patindex to find the parens and go from there.

I'll add my reasons in here why I approved this question. I think it's good, and I see the arguments why log shipping might be seen a easy.

However, getting rights...

Excellent job, Brian, and a great solution. Wish we had a good one for 2000, but having this handy would be nice for blocking people making attempts to crack security...

Et tu, Ninja, ROFL 🙂

Take it to PASS and it would be great for them to review stuff that is published elsewhere.

I don't want to get too much editorial stuff here. We like the...

We've talked about doing something with the briefcase, more like a "clipboard" of stuff, but making it public might help.

We have 4 or 5 articles on T-logs, but I...

Kerry,

A couple things. First I edited the subject so as not to disclose your email. I'd be wary of that.

Second, I'd create a role. Right click Roles, new role, and...