sql error trapping the restore command | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql error trapping the restore command

Hi I have a sql statement RESTORE LOG crm3 FROM DISK [email protected] WITH NORECOVERY And this works fine. But sometimes (intentionally) I specify a file that is either too young or
too old for the database
to restore. Essentially I am going through a series of files which need
applying. Some of them
are irrelevant. When one of these files is eno****ered the above command
yields Error on Server:, Source:.Net SqlClient Data Provider
Class:16, Msg 4326, State 0, Line 36
The log in this backup set terminates at LSN 2565000000217200001, which is
too early to apply to the database. A more recent log backup that includes
LSN 2569000000078800001 can be restored. The above error message is also fine. I simply now want to continue with the
rest of my sql commands.
But I cant seem to trap the error message so my script does NOT stop. I have tried using @@error <> 0 but it seems to be ignored. Does anyone know how to continue processing sql after such an event? Any help with this appreciated Regards
It wil not continue until the sequential process of log restores completes the process. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.