This recovery design is intended to be utilised when you don't perform backup from the transaction log in the database. In straightforward Restoration, It isn't your accountability to “vacant the log” (or “truncate the log”), as SQL Server will do this for yourself.The subsequent example passes a neighborhood char variable to the saved proc