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 2005 Forums
 SQL Server Administration (2005)
 Index Creation and thereafter

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2011-05-03 : 00:28:52
We have new indexes on 2-tables were in place to be created.

This is ok for creation.

(Offcourse, Full backup prior to the index and Tlogs will be safeguarded).

How to revert them in the event user complains. (I Know Simply remove the Created indexes and this will not solve my problem)

What would be the aftermath problems after creation of this index in place and what kind of Remedial steps needs to be taken.

Can anyone address please. Many thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-03 : 01:45:54
If they cause a problem (and there's no reason they should) simply drop the indexes that you created. Nothing more to it.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -