Function get_latest_restore_history_id

pub async fn get_latest_restore_history_id(
    client: &mut Client,
) -> Result<Option<i32>, SqlServerError>

Retrieves the largest restore_history_id from SQL Server for the current database. The restore_history_id column is of type IDENTITY(1,1) based on EXEC sp_help restorehistory. We expect it to start at 1 and be incremented by 1, with possible gaps in values. See:

• https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/restorehistory-transact-sql?view=sql-server-ver17
• https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver17