Sunday, December 30, 2012 12:29 PM
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.
Sunday, December 30, 2012 4:03 PMAre 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
Monday, December 31, 2012 6:30 AM
Please try the steps as below link wise :
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/
- Marked As Answer by Iric WenModerator Monday, January 07, 2013 8:50 AM