CODEWITHSUNDEEP
sql-serversql-server-2008
curious1
curious1

Reputation: 14717

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

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.

Upvotes: 0

Views: 39

Answers (1)

Dave.Gugg
Dave.Gugg

Reputation: 6771

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

enter image description here

Upvotes: 3

Related Questions