San_thi
Reputation: 103
How to create a new SQL Database on different drive
I have installed SSMS 2014 recently on my new machine, installations are in C: but my C: is not having that much enough space, so I need to create the new database on D:. Please help me on how can I do that ?
Upvotes: 5
Views: 13899
Answers (1)
HaveNoDisplayName
Reputation: 8517
you can set the path of .mdf, and .ldf file while creating the new databse. See the Red Arrow pointer. You can choose here your D drive path.
Steps:- Open SQL Server Management Studio >> Right Click on Database >> Choose New Database >> Then below dialog box will be shown.
Upvotes: 10
Related Questions
- How to create a new database in MS SQL Server?
- Create database and move mdf files to SQL default location
- How to create a new database and tables inside it in SQL Server?
- Create a database using T SQL on a specified location
- What is the proper way to move a database from one drive to another in SQL Server 2005?
- Create a database from another database?
- How to create a new database in SQL Server 2005?
- Create new Database in SQL Server 2008 R2
- SQL Server Management Studio - Create database with files at specific location
- new database in SQL Server