Restoring Backups with STANDBY Mode

[Guillermo_Osorio]

Hello,

I am exploring SQLBackupAndFTP for managing SQL Server backups and restorations. I have a specific requirement:

I need to restore a database while keeping it available in read-only mode during the restoration process, similar to SQL Server’s STANDBY option in Transact-SQL. This feature is crucial for allowing users to query the database while I sequentially apply full backups, differential backups, and transaction log backups.

For example, in SQL Server, I would typically use the following command:

RESTORE DATABASE MyDatabase
FROM DISK = 'C:\Backups\FullBackup.bak'
WITH STANDBY = 'C:\Backups\rollback_undo_file.bak';

This approach keeps the database accessible for read-only operations between incremental restorations.

Does SQLBackupAndFTP support this type of restoration process with the database in STANDBY mode? If not, is there a recommended workaround or a feature roadmap for implementing this functionality?

Thanks

[Oleg]

Hello Guillermo,

Thank you for your question.

You can achieve a similar result using a Log Shipping job. This feature includes the option to “Keep the database in Standby/Read-Only mode after restore”, which may meet your requirements.

For detailed instructions on setting up a Log Shipping job, please refer to the following guide: Log Shipping Job - SQLBackupAndFTP Documentation