• 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.

The Most Important Backup Setting in Plesk 9.x that is completely undocumented!

T

Tony Valenti

Guest
Hi Everybody,
I've been having a real problem with Plesk 9.x because the backup component does not create native (.BAK) MSSQL Database Backups, but instead creates a "script export". The problem with script exports is that with complex databases, many times, they do not correctly export, and if you have a 10GB database, you really don't want to be relying on a SQL Script.

Well, after quite a bit of research (thanks ProcessMonitor!) I was able to figure out that there is a hidden option in Plesk 9.5 (it might exist for other versions as well) that will let you inform plesk that you would still like for it to take native MSSQL Backups!

I wanted to document this feature and get it posted on the forum that way everyone else can see and utilize this as well.

This requires editing a key in registry, so if you're not comfortable doing this, then don't do it:
1) Open up regedit.exe
2) Nagivate to: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config
3) Create a new String Value named "DumpMsSqlToScript" and set its value to "false".

Poof! Plesk will now take reliable backups of your MSSQL Databases!
 
Tony,

Could you please specify how your MSSQL server is registered in Plesk? As 'localhost', 'localhost.localdomain' or '127.0.0.1'?
 
Hi

We aried this for one of our servers and it failed to create sql dump file.
is there anything else to change?

<?xml version="1.0" encoding="utf-8"?>
<execution-result status="warnings">
<object name="domain.com" type="domain">
<message code="InformationalException" severity="error">Cannot dump database content dbname of type mssql'</message>
</object>
<object name="domaina.com" type="domain">
<message code="InformationalException" severity="error">Cannot dump database content dbname of type mssql'</message>
</object>
</execution-result>



Hi Everybody,
I've been having a real problem with Plesk 9.x because the backup component does not create native (.BAK) MSSQL Database Backups, but instead creates a "script export". The problem with script exports is that with complex databases, many times, they do not correctly export, and if you have a 10GB database, you really don't want to be relying on a SQL Script.

Well, after quite a bit of research (thanks ProcessMonitor!) I was able to figure out that there is a hidden option in Plesk 9.5 (it might exist for other versions as well) that will let you inform plesk that you would still like for it to take native MSSQL Backups!

I wanted to document this feature and get it posted on the forum that way everyone else can see and utilize this as well.

This requires editing a key in registry, so if you're not comfortable doing this, then don't do it:
1) Open up regedit.exe
2) Nagivate to: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config
3) Create a new String Value named "DumpMsSqlToScript" and set its value to "false".

Poof! Plesk will now take reliable backups of your MSSQL Databases!
 
Back
Top