How do you recover data storage in SQL Server?

A stored procedure that provides this type of recovery in SQL Server.
A database consists of two files, MDF database files and LDF log files
1.sp_attach_db [@dbname =] ' dbname ', [@filename1 =] ' Filename_n '
Add a database to the system, specify the database name in dbname, filename_n the file and log files for the specified database. For example, I have an JI library that stops SQL Server service backup JI_DATA.MDF,JI_LOG.LDF, starts SQL Server, deletes the library, and then copies the two files to the SQL Server data directory, in query Analyzer executes the following statement:
EXEC sp_attach_db @dbname = N ' Ji ',
@filename1 = N ' D:mssql7dataji_data.mdf ',
@filename2 = N ' D:mssql7dataji_log.ldf '
Will add this library to SQL Server group.