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

Written by
Rate this item
(1 Vote)

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]
 

 

Read 1595 times Last modified on Tuesday, 12 January 2016 10:20

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.