Blogger

  • This email address is being protected from spambots. You need JavaScript enabled to view it.

    Recent items

Login

Friday, 25 September 2015 09:40

ContentDataBase deletion error

Hi,

if you're trying to remove a ContentDataBase following these steps

  • Remove the ContentDataBase from the Central Administration
  • Inside SQL, the DB is not removed. If you try to delete it (right click on the DB name and click on delete button) yuo will receive a SQL error (615 in my case)

and not works, try to execute the following SQL Commands, it works for me

Show/Hidden sql code

View source
 
 
 
USE master
 
 
GO
 
 
ALTER DATABASE [databasename]
 
 
SET OFFLINE WITH ROLLBACK IMMEDIATE
 
 
GO
 
 ALTER DATABASE [databasename] SET emergency 
 
 
DROP DATABASE [databasename]
 

 

Published in SharePoint