Formulation of SQLBackup Restore Command with variables

I'm trying to restore logs into a SQL database. I'm trying to pass a variable for the log file location but I'm receiving an 850 error which apparently is a Syntax Error. I've tried all varieties of single quote marks in various different places even though I don't believe quotes are required here.
If I pass the full path without the variable the restore works fine. The screen shot shows the variable's contents which matches the full path. Could anyone offer the correct syntax to try please. I'm assuming SQL Backup Pro allows the passing of variables into a restore.

Image: /hc/user_images/01JKDM77Q8A3YWZRF7BXEAF56D.jpeg

Codeweavers Infrastructure November 13, 2023 11:38

Comments

1 comment

Thanks to the following I've resolved it :
https://forum.red-gate.com/discussion/2824/using-variables-with-restore-command

The correct syntax is :

SET @TSQLArgs = '-SQL "RESTORE LOG [workdb] FROM DISK = ''' + @LogFileToRestore + ''' WITH RECOVERY"';

CWInfrastructure November 14, 2023 10:26

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Formulation of SQLBackup Restore Command with variables

Comments

Add comment