As you can see from the above screen shot it ends up in c:\program files\common files\microsoft shared\web server extensions\14\data\mssql10.sharepoint\mssql\data.
Now there is nothing really wrong with the location per se but it sure is a mouthful. Personally, I don’t like long data paths as it generally adds complications. Now I know that the content database location can be moved and I certainly hope that SharePoint Foundation 2010 beta includes a wizard to do this because I’d actually like to move ALL the SharePoint data (content databases, search index, configuration files, etc) into a single directory somewhere just off the root of my drive.
The reality is that I’m not really expecting to find a wizard to move all this data so I suppose I’ve just gotta get used to it. I’m I the only one that thinks doing this has made things more complicated?