Nice comparison with zipper and bad code, decisions etc.

I agree Tim, none of us are perfect, so in the event of a "not on purpose" mistake, or even if anything...

Agreed.

A formal Database or formal Database Administrator?

Results?

Ask yourself the following questions:

1. How many DB's will be hosted

2. How many concurrent connections

3. What is the current average IO statistics?

4. What on average is your data growth?

Since...

primary = master?

-then, do you have a backup?

-- you will have to start sql in single user mode (-m) and restore it.

if master <> primary

do you have...

open attachment

Upload your current dtsx package for us to see what you need and assist.

You could prevent it by defining the permissions on specific accounts.

Have you checked the job history info on the failing job?

It should give you a clear description of the issue, in which step etc.

If its a permission issue, and...

Are you using a single generic account to authenticate users from the app to SQL?

You will have to define persmissions on the accounts.

Try different installation media?

Errors are not very descriptive, except that there is a issue with the msi.

Read: BOL

What sort of authentication to your exchange server, did you use in your mail profile?

You will have to have exclusive access to the current DB to modify/overwrite/delete it.

This means you will have to close all current connections to it before changing it.

You could however:

Restore...