Attach / Detach A Database Freezes the Dialog

Question

Hi,

I am unable  to Attach / Detach a Database. When I click on the ADD button under the Attach/Detach Dialog Box, it freezes by displaying the displaying the Title as "Not responding" We have purchased a Licensed SQL Server 2012. I restarted all the SQL Services, even the Server as well but in vain.

It is causing a serious delay in my completion of a project.

I kindly request please anybody suggest me what actual the problem is and a remedy as well.

Thank You,

Abdul Anoop

Saudi Arabia

Answer 1

Are you able to execute the command as a query? It sounds like SQL Server is having troubles determining the default path for databases or it is not accessible under the account you run SSMS. 

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Hi

Please try the steps as below link wise :

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

have you tried to use the script as below :

-- Attach SQL

EXEC sp_attach_db @dbname = N'AdventureWorks2012', 
    @filename1 = 
N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_Data.mdf', 
    @filename2 = 
N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_log.ldf';

--Detatch SQL

EXEC sp_detach_db 'AdventureWorks2012', 'true';

If not working then update us what error will raise ?

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/