Can't save database default locations in SQL Server

sql sql-server sql-server-2012
jb_bryant picture jb_bryant · Sep 27, 2014 · Viewed 20.2k times · Source

I'm trying to change the default directories for data and logs using SQL Server Management Studio. I change the path then click ok but it always reverts back to the old directory in Program Files. Anyone else seen this bug? I'm using SQL Server 2012 Standard.

I do see that the correct values are saved in the registry, but they aren't being obeyed by the studio or other connecting applications that would create new databases.

Answer

md4 picture md4 · Sep 27, 2014

According to Microsoft, you must restart the SQL Server service for this to take effect.

You can do this easily via the Configuration Manager, or via the services.msc snap-in if you prefer that.

Related questions

Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More
Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
SQL Server IF EXISTS THEN 1 ELSE 2

Using Sql Server 2012. I have a stored procedure and part of it checks if a username is in a table. If it is, return a 1, if not, return a 2. This is my code: IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName =…

Read More