SQL Server. mdf file import or replace

New Database Test

place where the. mdf file is placed at the red Line

If your SQL Server service starts up and you are unable to manipulate these, you need to stop the service and then go to manipulate the file additions and deletions,

Go to the red line here to delete the original test.mdf file and log file

Take the test.mdf you want to replace and paste it to the address on the Red line,

Start the SQL Server service

Execute sql:exec sp_attach_db ' test ', ' C:\Program Files\Microsoft SQL Server\mssql\mssql\data\test.mdf '

Could have reported a mistake.

Database name already exists, let you change a name,

Don't worry about this error, restarting the SQL Server client should be good. Log file, it will also be created automatically.

SQL Server. mdf file import or replace