Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Specify location of data files
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01126868
Message ID:
01126969
Views:
22
>>I'm creating a new database in SQL2005. In SQL2000 and before, I was able to specify the location of the data files, but it doesn't appear that SQL Management Studio Express allows you to put the files where you want.

>Click on the ellipsis (...) button in the path column of the grid. You can change the data path and log path individually.

Can you be more specific? I don't see an ellipsis, and this is what I was looking for. Again, I'm using SQL 2005. Sounds like you are talking about how to do this in SEM in SQL 2000 and before.

>Why don't you like putting data files in SQL servers space under Program Files?

I don't like co-mingling program files and data. This is hardly a novel idea - I think I first got the idea from one of Whil Hentzen's books, and I agree with the philosophy.
Del
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform