I don't think anyone has brought up many of the questions that are driven by non-dedicated instances:

Do you require any server-level role rights and why if yes?

Do you...

Always been a big fan of the WROX series - easy to read, yet detailed at the same time. I've hit the series as a noob going into SQL...

You touched on the solution yourself, create an SSIS package with an FTP task that accomplishes what you want (grabbing .bak and .trn files from Server A and FTP-ing them...

How familiar are you with SQL Server Management Studio? You could script out the database tables and format it to fit your "data dictionary" needs.

May we ask why you're looking at doing this? Is your DB structure and security changing that frequently that you need to essentially "backup" the structure on a regular...

I can attest that leaving the default settings in place, without reserving memory for non-SQL functions even on a server dedicated to only SQL causes problems. We had issues...

That would be my concern. It's my understanding that it is being deprecated, but I have not seen anything formal on that.

OK, not to jump on the Backup/Restore bandwagon, but it is the best option and the easiest option.

Create a cursor for the users in the database (omitting any users you do not wish to drop) assign it to a variable @user and then use as follows: ...

Sounds like you may be able to utilize Notification Services to accomplish this.

We use a product called Clarity. It is SQL or Oracle based on the RDBMS-side.

I've always used a cursor to dynamically create a SQL statement that will change object ownership. Unfortunately I can not give you that query (PTO and no access to...

Chad, are you getting a specific error message?

The script you presented would append, not overwrite.

Overwrite = WITH NOFORMAT, INIT

Append = WITH NOFORMAT, NOINIT

Oh, one more thing, are these drives SAN-attached?

- Tim