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 (,).