how to create database with in the sqlserver some error

Question

Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mydatabase.mdf' because it already exists. Change the file path or the file name, and retry the operation. Msg 1802, Level 16, State 4, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. how to solution for the above problem

Amit Gupta · Answer

As you had already mentioned in your question,  .... because it already exists. Change the file path or the file name, and retry the operation....   What else it required to ask?   Just change the database name, must be a unique name

Bryian Tan · Answer

I agreed with @Amit Gupta +1. The error clearly indicated that the mydatabase already exists on the database server. Either save the database mdf at a diffrent location or give it a different name or drop/delete the current mydatabase or restore it.

Asma Khalid · Answer

check the location C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ as metioned in the error message. Go to Run command and type "services.msc". Locate SQL server instance and stop the SQL server instance service. Now on the mentioned path remove the file "mydatabase.mdf" if it already exist and start the SQL server instance service which you have stopped. You will be able to create the desinated DB now.