MS SQL Maestro online Help

Return to chapter overview

Attach Database

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

Nov 1, 2008

MS SQL Maestro 8.11 released

Introduces a new Dependency Tracker tool, support for some SQL Server 2008 new features, and a lot of interface improvements.

Jan 8, 2008

MS SQL Maestro 8.1 released

Extended property management, SQL server logs analysis and some other features.

Oct 16, 2007

MS SQL Maestro 7.10 released

Features a new Backup Database tool, Attach and Detach Database Wizards, cancellation of long-running queries, SQL Formatter for DML statements and more.

More news

Feature of the day

Parameter Editor

MS SQL Maestro ermöglicht die Prozedurparameter durch den entsprechenden Editor zu verwalten.

Login management

MS SQL Maestro hat effective Wizards für die Verwaltung von vier Typen von SQL Server Logins: Windows Authentication, SQL Server Authentication, Certificate, und Asymmetric Key.