SQL Server: How to change default path of physical MDF and LDF Files while creating database

When you install SQL Server say version 2014, the default path of physical MDF and LDF files would be "C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA". To change this default path to some other path you should

Right Click on the server - Click Properties - Click Database Settings - Specify path under Data and Log provision provided as shown below.


Posted by

2 comments:

  1. Jeramy S HickNovember 13, 2024 at 9:13 PM

    Thank you for this well-explained post. Don’t miss this profile for additional information Free IQ Test. IQ tests provide insights into different cognitive strengths.

    ReplyDelete
  2. Jeramy S HickSeptember 15, 2025 at 4:12 AM

    Your detailed explanation made everything clear, thanks for that. Read this profile to explore more Aim Trainer. Aim Trainer is a simple online tool that tracks aim progress over time.

    ReplyDelete

Subscribe to: Post Comments (Atom)