September 11, 2008 at 11:57 am
I have changed the Default Database locations AFTER installation of SQL server. If i create a db in the UI it uses the new locations yet if I run a simple script "Create database TEST1" it uses the old locations. I restarted the SQL service and created TEST2 and it used the NEW locations. My question is, is there a way to update the SQL engine to use the new locations without restarting the service?
Jimmy
"I'm still learning the things i thought i knew!"September 11, 2008 at 12:18 pm
When you click on the server and change the database settings it does not say you have to restart the service. When I did that and tried to create a new database it defaulted to the new location
September 11, 2008 at 12:25 pm
It does go to the new location in the UI. However if you script it does not. Try running "create database TEST1". If you have not restarted your service it will install the db files to the old location.
Jimmy
"I'm still learning the things i thought i knew!"Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply