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.
| Author |
Topic |
|
anaylor01
Starting Member
28 Posts |
 Posted - 2011-11-15 : 11:39:28
|
| Can this be done without breaking the cluster? I need to do some maintenance that can't be done directly on production. My idea is to do it on the clustered server and then move the data files over to production. |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-15 : 11:44:11
|
| Can you explain more? btw, recreating indexes doesnt need you to break cluster. |
 |
|
|
anaylor01
Starting Member
28 Posts |
Posted - 2011-11-15 : 12:02:32
|
| The indexes cannot be dropped and recreated on production. So I want to do it on the clustered server and move the data files to production. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-15 : 12:59:19
|
| Moving data files would mean you're replacing the production database with the other one. Anything in the prod database would be lost that's not in the one you worked on. Sure that's a good idea?Why can't you drop and recreate the indexes on production?--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Drop and recreate indexes on a clustered server