in Production our database files are spread out as follows:
E: drive (120GB) contains the niku_Data.mdf (32GB) and users_small.ndf (82GB) files.
F: drive (100GB) contains the index_small.ndf file. (55GB)
G: drive (100GB) contains the users_large.ndf file (66GB)
H: drive (100GB) contains the index_large.ndf file (66GB)
As you can see, we are running low on space on our E: drive. This was an issue a few months ago also and we allocated the drive an extra 20GB. Rather than continuing to allocate more space as the drive's space is used up, I wondered if it was possible for me to relocate the niku_Data.mdf file to the D: drive, which has over 100GB free space.
The main concern is of course how this could potentially impact performance. Has anyone else ever attempted anything similar? Obviously we would test this in our non-Production environment firstly, where the set up is the same as Production.
Many thanks for your advice on this.