MSSQL DB Disappeared

[zamarax]

A domain I host had an MSSQL DB setup and everything was working fine, infact everything is still working fine, what has happened however is that the DB has disappeared from the Plesk CP, it doesn't show under the Admin CP login nor the domain CP login, I can however RDP into this box and access the DB under SQL Server Management Studio, so it's there and it's working, my question is, can I manually restore the DB LISTING (not the actual DB itself) to the domain that it should belong to? I have tried to re-add the DB in the CP however Plesk give me the error of the DB already existing.....which ofcourse it actually is.

Server is Win2k3
MSSQL Workgroup
Plesk 8.2

Thanks in advance!

 

[DmitryT]

zamarax

You can try to do the following:

1) rename your current MSSQL database and backup it with SQL studio tools.
2) Remove the entity about MSSQL database from Plesk database:

> DELETE FROM data_bases WHERE name = 'YOUR_MSSQL_DB_NAME';

Please remember the database ID for future reference.

3) Create it anew in Plesk with exactly the same name;
4) Update Plesk database and change data_base id with the previous one:

> UPDATE data_bases SET ID = 'OLD_MSSQL_DB_ID' WHERE name = 'YOUR_MSSQL_DB_NAME';

5) Restore database content with SQL Studio restoration tools.

Keep in mind this is quite simlpified approach so you should be very carefult and backup all the possible antities before performing any changes.

 

[zamarax]

worked!

zamarax

You can try to do the following:

1) rename your current MSSQL database and backup it with SQL studio tools.
2) Remove the entity about MSSQL database from Plesk database:

> DELETE FROM data_bases WHERE name = 'YOUR_MSSQL_DB_NAME';

Please remember the database ID for future reference.

3) Create it anew in Plesk with exactly the same name;
4) Update Plesk database and change data_base id with the previous one:

> UPDATE data_bases SET ID = 'OLD_MSSQL_DB_ID' WHERE name = 'YOUR_MSSQL_DB_NAME';

5) Restore database content with SQL Studio restoration tools.

Keep in mind this is quite simlpified approach so you should be very carefult and backup all the possible antities before performing any changes.

This actually worked perfectly!

Thanks DmitryT!