Vaibhav Gaikwad
Microsoft .NET developer
Bla Code! Bla Code!

February 2018 Entries

SQL Server: Moving DATA and LOG file to different location

The default location of the "data" and "log" files for SQL Server database is "C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQ... for version 2016 unless it is set differently during the installation process.The core issue in discussion here is the copy the database files from one drive to another in case of a scenario where you current drive is getting exhausted. In my case the C: drive was running of space and I wanted to move the files to F: driveSo start the SQL Management Studio ......