kevriley

/* *************************************************************************************** 
retrieve standby filepath from tlog 
credit for original idea is not mine, but I cannot find the original post any more 
*************************************************************************************** 
https://rileywaterhouse.co.uk/where-is-the-standby-file
*************************************************************************************** 
*/

DECLARE @database sysname;
SET @database = N'AW';