SQL Server data disk upgrade/downgrade

I had to move (copy) SQL server data files to a smaller (and different) disk with same drive letter. This sounded like a trivial operation, but managed to find out the hard way, it is not the case.

Googling this matter also displayed more advanced method with alter tables and taking DB’s offline.

For […]