It works very well, except the err from SQL Server 2008:

Msg 155, Level 15, State 1, Line 1

'truncate_only' is not a recognized BACKUP option.

Thanks for sharing!

Ruth

Thanks Amar!

I copied your code again, and now getting this message:

Msg 170, Level 15, State 1, Procedure OPS_SP_DetailSPID, Line 12

Line 12: Incorrect syntax near 'max'.

Thank you very much!