Changing Default Database File Locations in SQL Server 2014
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.
