Hello Everyone and thanks for your help in advance. I am setting up a new development environment on a Windows 7 Ultimate laptop. I successfully (I Think) installed SQL Server Standard Edition and then applied SP3, again I believe successfully. When I attempted
to create a database, I received the error message:
Create failed for database Test1 (Microsoft.SQLServer.SMO)
Could not obtain an exclusive lock on database 'model'. Error 1807.
Additionally, I am attemtped to copy databases from my old environment to the new one. When I try to attach a database and the dialog box opens, I then try to "Add" a database to the dialog window, however, each time I attempt this, the program stops
responding. Similarly, when attempting to perform a backup, the program stops responding when I attempt to browse to a backup file. I'm not really sure what is causing this or where to start troubleshooting. Any help would be greatly appreciated.
View Complete Post