Choose your database:

Partners

Testimonials

Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".

DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

Download

Buy

MS SQL Maestro online Help

Return to chapter overview

You can attach a copied or detached SQL Server database. In SQL Server 2005, full-text files that are part of a database are attached with the database. Generally, attaching a database places it in the same state as it was in when it was detached or copied. However, in SQL Server 2005, attach and detach operations both disable cross-database ownership chaining for the database.

To run Attach Database Wizard, select the Database | Attach Database main menu item.

•	Selecting server to attach the database to

•	Specifying additional parameters

See also: Detach Database

Return to chapter overview

Company news

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Jun 29, 2017

MS SQL Maestro 17.6 released

New version features support for SQL Server 2017, support for row-level security policies, custom labels and colors for server nodes in Database Explorer, and some other useful things.

Jul 27, 2015

MS SQL Maestro 15.7 released

New version features support for Azure SQL Database and SQL Server 2016, updated data export/import tools, colored tabs, new encryption algorithms in data grids and some other useful things.

More news

Feature of the day

Database Designer

MS SQL Maestro allows you to represent SQL Server databases as ER diagrams.

Easy File Group management

MS SQL Maestro allows you to cope with file groups and their files.