Restore the SQL Server database from the mdfldf File

Welcome to the Windows community forum and interact with 3 million technical staff. 1. Run USEmaster directly without creating a database. GOCREATEDATABASEtestON (FILENAMED: ProgramFilesMicrosoftSQLServerMSSQL10.MSSQLSERVERMSSQLDATAtest. mdf), (FILENAMED: Pr

Welcome to the Windows community forum and interact with 3 million technical staff> GO to 1: run the USE master directly without creating a DATABASE; go create database test ON (FILENAME = 'd: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ DATA \ test. mdf '), (FILENAME = 'd: \ Pr

Welcome to the Windows community forum and interact with 3 million technicians>

1: directly run without creating a new database

USE master;

GO

Create database test

ON (FILENAME = 'd: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ DATA \ test. mdf '),

(FILENAME = 'd: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ DATA \ test_log.ldf ')

For attach;

GO

Copy other files to the corresponding location.

2: refresh the page.