Superbutler
New Pleskian
- 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.
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.