• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Delete database Error

N

nickmm

Guest
Hello,

I'm trying to delete a MSSQL database, but I'm getting this error:

Delete database user failed: Database 'database_name' cannot be opened because it is offline.
---------------------- Debug Info -------------------------------
0: plib\DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'database_user', string 'database_name')
1: plib\DatabaseManager.php:105
DatabaseManager->deleteDatabase(object of type Database)
2: plib\class.DataBasesList.php:244
DataBasesList->remove(array)
3: htdocs\domains\databases\removeDataBases.php3:41


I believe that the problem is that this database not exist in the server (exist on Plesk, but not in the server).

How can delete this database? I have tried make a reconfigure for the domain name, but this action not resolve my problem.

Thanks in advance,

Nickmm
 
You can manually create the database on the sql server, or if its there but in an offline status you can bring it backonline into a multi user state. You can also attempt to manually delete the DB data from the plesk database so that psa no longer will tihnk the DB exists at all
 
If some one are having this problem the solution is bring online the database (run: Alter database YourDBName Set Online)

Thank,

Nickmm
 
Back
Top