:::: MENU ::::

Attaching SQL Server database through SQL Server Management Studio (SSMS)

  • Jan 27 / 2009
  • 1
Backup and Restore, dbDigger, SSMS tips and tricks

Attaching SQL Server database through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to attach a database through SSMS. Follow these steps in your SSMS

Attach SQL Server Database-1

 

Attach SQL Server Database-2

 

Attach SQL Server Database-3

 

Attach SQL Server Database-4

 

Then click OK to start the attach process.

  • Anonymous

    Its good to see a basic type of task explained here. Students really need such tasks explained.

Consult us to explore the Databases. Contact us