CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2008
mcu
mcu

Reputation: 3512

SQL Server Management Studio - Create database with files at specific location

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: 4191

Answers (1)

marc_s
marc_s

Reputation: 755351

You can easily define both the path as well as the actual file name in the Create New Database Wizard:

enter image description here

Upvotes: 10

Related Questions