The Veristas backup will likely count as a full. Note that I'd recommend you stop using that agent since it can be problematic in a DR scenario. You want to...

The backup/restore pwd shouldn't need to be the same as the creation password. The creation password is needed to open the key.

Sam,

Sounds like things aren't that bad. Good to know.

We're here to help. Please start new threads for basic questions you have about how to do things. We will try to...

Andrew is pretty on here with what I think. The exceptions I'd make for production data is in a brake/fix or User Acceptance Test environment where the people verifying things...

Ahhh, Klingons asking questions. About databases? Could be interesting....

I thought Klingons used the laptops to cause damage when their phasers died.

wouldn't VMs come into the memory area?

Jeff, I'd think 64bit and Hyper-V. I've had quite a few other MVPs say they like this arrangement since they can bring up/tear down...

You should also review who has the ability to do this. It should not be many people.

You could broadcast that you are about to undertake this investigation and express concerns....

I'd tell him that both of these activities could cause a lot of downtime if there's an issue. Regardless of testing, though you should still test.

It's a risk issue. I'd...

Best of luck, Eddie, and I think we'd all be interested to know how this turns out.

:), whoops.

not implying developers are not people, but you need a person that is not a developer.

I can appreciate their dedication to VB 6, but that's part of why I suggested SSIS instead of going with BCP or something else. It's a programming environment, and sometimes...

Ted,

Thanks for the update.

http://www.sqldts.com/204.aspx

Is this data queried in real time? Any reason not to move to a more structured procedure like SSIS? If they can load 1TB in less than an hour, doesn't...