MS SQL Server - Any scripts that will create maintenance plans in SQL 2005

Author

Any scripts that will create maintenance plans in SQL 2005

Raji Arulambalam

2006-10-24, 6:32 pm

Hi
Using SQL Server 2005 SP1

Are ther any way to create scripts that will recreate the maintenance plans
that are on the server?

We need to rebuild the server with a different collation, so the master,
msdb and model will get recreated.

Also where are the configurations for database mail kept. No scripts to
create them.

Any place that has scripts that can regenerate the data that one requires?

Thanks

Tibor Karaszi

2006-10-24, 6:33 pm

You can connect Object Explorer to Integration Services and Export the maint plan to a file. After
the rebuild, import that file, and just re-create the jobs (or script the Agent jobs as well...).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Raji Arulambalam" <rajian0spam@ebop.gov0t.nz> wrote in message
news:O7P4Kd44GHA.4616@TK2MSFTNGP05.phx.gbl...
> Hi
> Using SQL Server 2005 SP1
>
> Are ther any way to create scripts that will recreate the maintenance plans that are on the
> server?
>
> We need to rebuild the server with a different collation, so the master, msdb and model will get
> recreated.
>
> Also where are the configurations for database mail kept. No scripts to create them.
>
> Any place that has scripts that can regenerate the data that one requires?
>
> Thanks
>

Sponsored Links