You just brought up something I think most people forget, that we as humans still have the power over computers.

It's a 50/50 thing, we need the speed, they need our...

I don't really think the poster would consider staying on SSC if he saw your post regarding his question, do you?

Even though this forum is maybe for blowing off steam,...

I would not suggest doing it, I may be wrong but I don't see any way of simply copying a maintenance plan...even if you could you look at challenges around...

Adam, I don't quite get...

Have to agree with Paul.

ETL for a whole db doesnt really make sense.

Backup and restore would be a good idea.

Check out Brent Ozar's blog...

http://www.brentozar.com/sql/sql-interview-questions/

Have you tried importing the DTSX packages from one SSIS instance to another?

Ensure you add encryption on them should there be stored passwords etc in them.

Hi Hugo, yes, looking at the last where statement, it was easy to determine the answer.

But, look at the wrong answer rate - 19 so far.

This question was purely to...

Yes, it's called a backup.

Vijay, how about trying a script posting us your effort, and then we'll see where we can assist.

There was a long thread about people just asking for scripts, instead of...

start of with creating a table with an ID column, and a column with your server/db names.

use the row ID's to get the server names in each loop, with a...

Even though your jobs reflect the new name, did you change the run as account as well?

Fully agree.

Bad formatting is almost as ugly as bad coding. When handing over your code/work you should

feel confident that any developer can look at it and be able...

Read up at

http://msdn.microsoft.com/en-us/library/ms144275.aspx

http://www.sqlservercentral.com/Forums/FindPost937448.aspx

please don't post duplicates.