MSSQL Server. LDF and. MDF file attach the SQL statement of the database

Attach the database.

Additional database:

Enterprise Manager
-- Right-click "Database"
-- All tasks
-- Attach a database
-- Select your. MDF file name
-- OK
-- If no. LDF file is displayed and whether to create it, select "yes"

Query the method in Analyzer:
-- Data files and log files
Sp_attach_db 'database name'
, 'Data file name (*. MDF must contain a directory) '-- multiple data files in the database can be separated by commas (,).
, 'Log file name (*. LDF must contain a directory) '-- multiple log files of the database can be separated by commas (,).

-- If only data files exist
Sp_attach_single_file_db 'database name'
, 'Data file name (*. MDF must contain a directory) '-- multiple data files in the database can be separated by commas (,).