How to know if backup file is available before trying to restore I have a restore job, but i want to add a step before restore step to know if backup file available.so that it should go to restore step only if backup file available.Please let me know a query which i can use before restoration step
I've found an answer on SO that could help you:

Check for file exists or not in sql server?

Using this function:

CREATE FUNCTION dbo.fn_FileExists(@path varchar(512))
RETURNS BIT
AS
BEGIN
     DECLARE @result INT
     EXEC master.dbo.xp_fileexist @path, @result OUTPUT
     RETURN cast(@result as bit)
END;
GO


You could check if the backup file exists before to restore it.