All the environments I've been in typically use a two hop approach, backups are written to disk and the backups are then swept to tape which are taken offsite. ...

I'm *guessing* but does the owner of the database or the caller exist as a user in the msdb database and exist in that role? You are crossing a...

Well Grant can correct me if he feels it necessary, but there are very few cases where I would want to setup mirroring, I'm really hesitant about the two-phase commit...

when the database is created on the destination side set its size close to or above the ending size it will be, limit the number of times it has to...

It depends.. Sorry, but it does..

Initially the 60 row table probably will, but I can think of several possible factors:

1. Table width, how many columns, how wide are the...

That 14hours is probably better than it would be if it was 32-32..

Are the database files pre-sized? If not then it will spend a lot of time growing them.....

Per Microsoft, the backup structure between 32 and 64-bit is the same, so you can restore backups between the same version but different architectures at will.

CEWII

I have to agree with Lowell, you are between the proverbial rock and a hard place.

Being a fella who doesn't generally believe in always or never it pains me to...

I think Ed is on the right track, doing this at the DB instead of in SSIS is a better approach. SSIS does not offer a between type lookup,...

Agreed..

CEWII

I would probably opt for transactional replication then. It requires some setup but isn't too heavy on the source system. I would definitely replicate to another database and...

Although not pretty, you could build a SQL agent job that runs often (every 1-2 minutes) that looks for the command and kills the connection if it sees it. ...

So what happens when you move it to production? Also, what kind of source control tool or methodology are you using? Do...

I would ask two questions before positing a solution.

Is this for a LOT of tables or just a couple? I know that auditors would LOVE to have this for...

I would point out that if you compile this code on a new database it will fail..

The ALTER statement only works when it already exists. you might look at...