Creating ReIndex Job on Multiple databases on different servers
-
How would I go about creating a job on one server /database to create it on several... at once.... ?
Any scripts thoughts or ideas regarding this?
thanks,
Jonathan
-
I think RedGate has a product for that kind of thing. Might check it out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
I know of SQL Farm Combine and Red-Gate SQL Multi Script that can execute a script against multiple servers. SQL Server 2008 Management Studio will also have this feature.
If you need to do reindexing against multiple databases I have a stored procedure that can do this.
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
Ola Hallengren
-
You could use SSIS
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply