Can MSSQL server be configured to create a database in a specified folder?

Question

I use SQL Server 2008. Each time when I create a new database with it, it attempts to the database in the destination folder like this:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

I understand that I can manually change it. But I am curious whether the default destination folder can be configured to another folder.

Dave.Gugg · Accepted Answer · 2015-05-11 20:51:29Z

3

This can be configured in the Database Settings of the Server Properties:

enter image description here

answered May 11, 2015 at 20:51

Dave.Gugg

6,8013 gold badges26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1