Issue Testing Disaster Recovery - Windows: Stored Procedures missing after full backup restoration on another server.

[Superbutler]

Server operating system version

Windows Server 2022 Datacenter Version 10.0.20348

Plesk version and microupdate number

18.0.59 #2

Hi,

We are testing disaster recovery on Windows Server.

We performed a full backup of Plesk, including databases and subscriptions, with the database located on the same Plesk server. The backup was successfully generated. We then restored this backup on another server with the same version of Plesk, and the restoration process was successful. However, when we attempted to access the application, it resulted in an error.

Upon reviewing the application logs, we discovered that some stored procedures were missing. This issue might be due to database referential integrity. We did a manual fix by generating a comparison script using MS Visual Studio and executing it. Our application was up and running after this.

Please note that we have already tried disabling the triggers and constraints before restoring the Plesk backup using the following commands:

-- Disable triggers
EXEC sp_MSforeachtable "ALTER TABLE ? DISABLE TRIGGER all";

-- Disable constraints
EXEC sp_MSforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all";


Could you please advise on how to ensure all database components, including stored procedures, are accurately backed up and restored?

Thank you.

 

[Kaspar@Plesk]

Just to understand the issue a bit better, you saying that some Stored Procedures are restored but other are missing after a backup restore?

 

[Superbutler]

Hi Kaspar, thanks for your message. Yes, that is correct. Some of the SPs were not executed in the restoration process.

 

[Kaspar@Plesk]

I see. Best suggestion I have would be to contact Plesk support for an investigation, as I am unsure what causes this behavior. To sign-in to support please go to https://support.plesk.com

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk