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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-05-19 : 10:35:52
|
| I want to move index file(69 gb) to different location.Right now data and index files are on the same drive(e), I am trying to move index files from e drive to f drive, so I will get 69 gb free on e drive . Can anyone please advise me what precautions I should take and advise best practice.Thanks in advance |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-19 : 11:10:50
|
| This operation can not be done online. You may need an outage for this. Alternatively consider partitioning.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-19 : 12:51:34
|
| make sure to take a full backup before moving files to other location. |
|
|
|
|
|
|
Move Index file to different location