attach / detach mssql 2008 sql server manager [SOLVED]
- by Tillebeck
An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager...
Not much to do but write a mail to the service provider asking to have the database attached again. The service porviders answer: Not posisble to attach again since the SQL Server security has been violated".
Rolling back to last backup is not the option I want to use.
Can any one give feedback if this seems logic and reasonable to assume that a detached database in a SQL Server 2008 accessed through SQL Server Manager cannot be reattached. It was done by rightclicking the database and choosing detach.
-- update --
Based on the comments below I update the question with the server setup.
There are two dedicated servers:
srv1: Web server with remote desktop and an Sql Server Manager
srv2: Sql server that can be accessed through the Sql Server Manager on the web server
-- update2 --
After a restart of the server the DBA could suddenly do the attachment of the database. And I guess that after the restart it was a simple task. So all of your answer were rigth! It seems that I can only mark one as a correct answer so I marked the first answer correct. But all are correct answer.
Thanks a lot. Without posting the link to this thread then we might had so suffer while watching our database beeing restored by a backup :-) Thanks a lot.
BR. Anders