MS SQL Server 2008 R2 Management Studio bug: cannot attach a database

Question

I can't attach a database in SQL Server Management Studio for MS SQL Server 2008 R2. I try this:

But then I get:

This is obviously a UI bug. But maybe I can attach a database using some sort of T-SQL script?

Answer 1

Hello,

Run SSMS with the “Run as Administrator” option. Assign sysadmin role to the account you are using to attach the database. For more information, please see the following post:

http://connect.microsoft.com/SQLServer/feedback/details/553392/actual-value-was-1-microsoft-sqlserver-gridcontrol-error-when-attaching-database

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 2

Hello,

if you are facing problem using User Interface you can accomplish same using SQL Query.

CREATE DATABASE MyAdventureWorks 
    ON (FILENAME = 'C:\MySQLServer\AdventureWorks_Data.mdf'), 
    (FILENAME = 'C:\MySQLServer\AdventureWorks_Log.ldf') 
    FOR ATTACH; 

http://msdn.microsoft.com/en-us/library/ms190209.aspx

Answer 3

Hi Bogdan,

You could use sp_attach_db to attach a database to a server.

The following example attaches files from AdventureWorks2008R2 to the current server.

EXEC sp_attach_db @dbname = N'AdventureWorks2008R2', 
    @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\AdventureWorks2008R2_Data.mdf', 
@filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\AdventureWorks2008R2_log.ldf';

For more information, please refer to  http://msdn.microsoft.com/en-us/library/ms179877(v=sql.105).aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.