PSA db missing or deleted.....

[Sergej]

Hi Sergius
I am using PLESK 8,30 in my one server and 1 year testing this software.
Esterday i restarting server and see PSA db not preset in MSSQL server and db northwind, I am repair instalation, complet reinstall PLESK and psa not preset and not exist.
In backup this db not update. I dont understand where is problem. In my PLESK run only one domain my license is unlimited domain . In this server not hosting domain and pages, not viruses, not mail services. In MSSQL server run only this DB
Where you think problem, please help.

 

[Sergej]

If I go in administration I see this ERROR messageI change full path to .....
ERROR: PleskMainDBException
<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Cannot open database requested in login 'psa'. Login fails.

0: .....\plib\common_func.php3:594
db_mssql_connection()
1: .....\plib\common_func.php3:623
reconnect()
2: .....\plib\common_func.php3:584
db_connect()
3: ....\auto_prepend\auth.php3:79

 

[sergius]

Hello Sergej,

Please try to find psa database backup in the folder %plesk_dir%MySQL\Backup.

 

[Sergej]

Because I am use sameone MSSQL SERVER my backup DB files is other directory. In this directory %plesk_dir%MySQL\Backup I see only ZIP files and backup files mailenabled not backup psa IDF. If I run MSSQL server management and go restore DB, server not restore and write me: Cannot loígin to psa DB.
OK thank Sergius for you advice, because this server run only one real domain I today complete delete PLESK and install new, after write resolved problem or no.

 

[ally@]

actually this is default backup location for Plesk database even if it of MSSQL type
I would check the archives - they should contain backup files of psa database
not mdf ones to attach but regular SQL Server backup files

 

[sergius]

actually this is default backup location for Plesk database even if it of MSSQL type
I would check the archives - they should contain backup files of psa database
not mdf ones to attach but regular SQL Server backup files

Exactly.

However there is one issue - if MSSQL runs under NETWORK SERVICE then it cannot write into this location. In this case you should either run MSSQL under other account having appropriate rights (recommended) or allow NETWORK SERVICE to write into backup folder (security risk).