Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 maintenance plan for all databases

Author  Topic 

pvsramu
Starting Member

17 Posts

Posted - 2007-08-09 : 11:43:54
Hi,

I would like to know if its better to create ONE maintenance plan for all databases or create a maint plan for every database.

Thanks,
Ramu

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-09 : 15:39:05
either or depending on when you want to schedule it and how many DB's you want to include.

Ashley Rhodes
Go to Top of Page
   

- Advertisement -