Fixing misplaced SQL Server database files

SQL
Photo by John Carter

Recently I was moving a SQL Server model database log file to another disk. I made an ALTER DATABASE [model] MODIFY FILE... command a bit too fast and pasted the destination from a file browser window. Of course this set the log directory as the new ...

more ...