SQL2005 Additional database operation steps (sql2005 restore Database) _mssql2005

In the Object Explorer in SQL Server Management Studio, right-click on the node ' database ' and select ' Attach ' on the pop-up menu.

In the Attachment Database window, click Add, select the main database file to add, such as Cms_keleyi_com.mdf;

After adding the automatic association shows the details of adding a database. If you are no longer under the same path, you can manually modify the path to the correct secondary library file or transaction log file;

Click OK to complete the additional database.