Skip to content
Thomas LaRock
  • About
  • Work With Me
    • Author
    • Speaker
    • Data Expert
  • Blog
  • Contact Me
  • Resources
    • Portfolio
    • SQL Server Upgrades
    • SQL Server Books
    • Someday…
    • Blogger Disclosure

default

Changing Default Database File Locations in SQL Server 2016

June 22, 2017June 21, 2017 by Thomas LaRock
changing defailt database file locations sql server 2016

At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.

Categories Database Design, MSSQL, SQL MVP Tags backups, database, default, files, registry 2 Comments

Changing Default Database File Locations in SQL Server 2014

May 9, 2016February 24, 2015 by Thomas LaRock

When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.

Categories MSSQL, SQL MVP, SQL Server Performance Tags Data, default, log, server, SQL 19 Comments
Pro SQL Server 2022 Wait Statistics