• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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