Reputation: 3512
Using SQL Server Management Studio (SQL Server 2008 R2 Express), how do I create a database with files at an arbitrary location, say "K:\SQL_DATA
"? I have been able to create it at default location, detach it, move the files, attach it. But it sounds like a lot of unnecessary steps. I would like to use GUI if possible.
Upvotes: 3
Views: 4187
Reputation: 755207
You can easily define both the path as well as the actual file name in the Create New Database Wizard
:
Upvotes: 10