Any scripts that will create maintenance plans in SQL 2005

29 Sep 2006 5:22 AM

Raji Arulambalam

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

29 Sep 2006 7:10 AM

Tibor Karaszi

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/

Show quoteHide quote

"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
>

Thread options