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.
| Author |
Topic |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-07-23 : 11:05:17
|
| I have created an instance to store data in C:\Data. Now I want to change the store place to H:\Data how can I change that?Thanks in advance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-23 : 11:14:23
|
| In Management Studio, right-click the server icon, choose Properties. Under Database Settings you'll find text boxes to set default data and log file locations. |
 |
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-07-23 : 11:55:53
|
| thanks robvolk. But I can only see local drives. Is it true that I can only use local drives for data store? If I need to store the data in other file share (i tried but seemed not working) what should I do (I know there is a way using node something.)? thanks again. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-23 : 12:13:11
|
| If H: is a mapped drive, then that won't work. You'd have to use the UNC path, which is possible in SQL Server 2008 R2 but I wouldn't recommend it as the default setting. See here for more information: http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-1.aspx |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-07-23 : 17:34:24
|
| thanks robvolk.I tried UNC it works but I can't create a new db on it. It says user and password not recognized. I set the permission as Everyone FULL for the shared folder. Anyway I found the way of using mountvol command to create a mounted point on either mapped drive or other virtual drive, I am using Hyper-V. But this is still not what I want. I need to connect to a physical drive. Maybe I need try VMWare for virtualization.thanks again. very good link. |
|
|
|
|
|
|
Change instance store directory