Jana Sattainathan walks us through the process of moving a SQL Server data file from one drive to another:
Space got tight on a drive and I knew that there was space on another drive. I had already set this particular database with multiple secondary file groups/files (.ndf files) instead of a huge and single .mdf file (which would have made the whole thing a lot harder).
The procedure to relocate data files is extremely simple
Click through for Jana’s seven salvos of administrator success.