September 30, 2009 at 10:31 am
Hi Friends,
We are having data bases in 2 servers and index group was created in the same server. The database size is growing day by day. So we would like to seperate index to other server. We would like to move all (only)non-clustered index to new index group. HOw can i get only non-clustered indexes and move to new group.
i.e, I would like to create a stored procedure which retrives all non-clustered indexes in the current data base ( for all user tables) and execute create index ............ statement in the new group. HOw can I...........??????????
Thanks in advance,
September 30, 2009 at 2:04 pm
:pinch: shall I understand you are asking how to build indexes on Server-B pointing to tables sitting on Server-A?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply