Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: SQL Server Objects > Databases > Working with Databases > Attach Databases

Attach Databases

To attach a database

Right-click a database under the Databases node in the Object Explorer, and select Tasks | Attach Database.
Click Add to select the database file (*.mdf).

Complete the fields as necessary. Review the following for additional information:

Databases to attach	Description
Database File Location (*.mdf)	Click to locate the database file.
Attach As	Update the name of the database, if needed.
Database details	Description
Original file name	The data and log file names display for the selected database.
File type	The file type (data or log) displays.
Current file path	The current file path displays. Click to open the Browse for Directory dialog (enabled when you click the file location cell) to change the location where you want to find the selected file.
Message	Any messages for the selected file display.

Tips:

To remove a database, select the database row under Databases to attach and click Remove. You cannot remove a database from the Database details list.
To remove a log file, select the log file row under Database details and click Remove.