Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 File Directories.

Author  Topic 

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-10-17 : 15:29:29
Hey folks.

Quick question. During my install I meant to create a non-default instance folder structure. Instead of using
D:\MSSQL10_50.MSSQLSERVER\MSSQL

I want to have D:\MSSQL.1\MSSQL

Can I just update this or does something have to be updated within SQL. I currently have no databases.
Thanks for your help



Steve

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-17 : 15:37:10
You cannot just update this. You will need to reinstall it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-10-17 : 15:38:07
Wua wua wua.....

Steve
Go to Top of Page

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-10-17 : 15:42:40
Is there any way to modify the existing installation at all through the CD again?

Steve
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-17 : 15:51:33
You need to reinstall it in order to get the path that you want.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-10-18 : 03:16:03
You can move the default directories for the database files but not the database instance folders...then you would have to reinstall as Tara says. If you want to move the default directories for the databases you connect to the instance in SSMS, right-click the server level and choose properties, then choose Database Settings.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page
   

- Advertisement -