dbv147 (2/6/2009)
Hello,I need to move an index file to another drive and thought I'd get some advice on the best way to do this. The index is on an archive server so down time is not a problem. My plan was to shutdown the SQL services copy the file to the new location. Start up SQL then remove the original file from the file group then add the file to the same file group in the new location. Any suggestions or alternate methods are welcomed.
Thanks
It doesn't work that way !
All files in a filegroup contain the data in a balanced way (simply said:every file a chunk, one after the other).
What you can do is ad another filegroup and add a new file to this new filegroup.
Then move over the intended index.
Then, if needed, shrink the original filegroup.
Check books online (alter database) for details !!
This art. can help out with the actual move:
http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me