Steps to create new SQL Database in specified location using SSMS
1. Connect SQL Server Management Studio by entering SQL Server details.
2. Right-click on the node Databases, and click New Database…
3. Enter the new Database name and drag the below horizontal scroll bar into right-side direction as shown in below image.
4. Now, you can see the column Path which holds the default locations for Primary database file and Log file.
5. Either you can manually type the new database location for primary database file and log file or you can use browse (…) button to select the database location where you want to create new database files.
6. Click OK to create new sql database in the specified location. Now, you can see new database files are created under the specified location D:SQLDB instead of default sql primary storage location.
Morgan,
Thanks
Software Developer