Plesk 11.x / Windows :: Error Trying To Restore Database
Dec 14, 2013
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
Unable to restore database '17' Not valid backup: Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.). VERIFY DATABASE is terminating abnormally.
(Error code 22) ---------------------- Debug Info -------------------------------
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
When restoring a backup on Plesk 12, the error below is generated for some sites and the sites are only partially restored. Although the message talks about disk space, there is in fact plenty of free disk space - i.e. many GB. The backup was created on Plesk 11.5. The restore on Plesk 11.5 works.
I noticed that all the failed domains exceed the disk space allowed by their Service Plan. However, the 'Overuse is allowed' setting is selected. Strangely, I tried changing the Service Plan and retrying the backup and restore, and the same errors were generated.
<object type="domain" name="domain.com"> <object type="hosting" name="domain.com"> <message code="CantUnpackDomainContent" severity="warning" id="f3946c79-7ae2-4be2-8300-ba766bea7869"> <description>Can not deploy content of domain domain.com</description>
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info: Plesk 11.5 Windows 2008 R2 (64Bit) 3GB RAM MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
It fails with the error after about 1GB of RAM usage on the server.
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX' Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
i have make a full Plesk Backup on my Old Server with Plesk 12.0(Ubuntu) and will restore the Backup on my new Server with Plesk 12.0(CentOS).When i will restore the backup i get this error: "Error: The source file is not a valid XML file. If you supplied an archive file containing a backup from Plesk version 9 or later, then extract the contents of this archive, and process the extracted XML file with the converter. If you want to convert a backup file from a Plesk version earlier than 9, then you first need to process it with the pre9-backup-convert utility, and then process the resulting file with the pre10-backup-convert utility."
After a server migration, some critical Plesk settings were not copied across, even though the option to backup/restore panel configuration was used. e.g.
skeleton (vhosts.skel folder) php.ini (Program Files (x86)ParallelsPleskAdditionalPleskPHP5* folder) Default site (vhostsdefault folder) health config (Program Files (x86)ParallelsPleskadminconfcustom-health-config.xml) Additional Administrator accounts
Is there a way to get these things to backup and restore that I am doing wrong?
Are there other important settings/data that I have missed from that list? I am still paying to keep the old server in case I discover something else!
Using Plesk Backup & Restore for disaster recovery will lose these settings unless they take extra steps. e.g. I now have a simple batch file that copies these files to a private folder on one of the domains before the daily backup kicks in.
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit
PROBLEM DESCRIPTION When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database. The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server
STEPS TO REPRODUCE Tools & Settings -> Database Servers -> Add Databases server
ACTUAL RESULT Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'
EXPECTED RESULT A working database connection.
ANY ADDITIONAL INFORMATION These queries are logged by MySQL: