>Additionally, SQL Server 2005 creates MSQL.n directories for Reporting Services, OLAP, etc.
>
Thank you for the explanation.
>You can put the database files into any directory on a drive that is local to the machine hosting SQL Server. Also, default locations for database and log files can be set on the Database Settings page of the Server Properties form. On my local machine, I store most user database and log files in E:\SQLData, just to make them easier to find.
>
I like your approach. For easier backup, I keep all the data that I need to back up on drive D: so it would be better to move the SQL database to a folder like SQLDATA on the D: drive. If I wanted to relocate my SQL Server database from a sub-folder of MSSQL.1 to another folder, do you suggest that I detach the database, copy it to a new location, and then attach it from there?
Thank you so much for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham