Is there a way to know the free disk space available on the drive that the back up file will be created?
For example, SQL Server is installed in Server 1 and the back up file is scheduled to be created in network \server2.
Is there a way to know the free space of \server2?
If I execute
xp_fixeddrives, it will only give drive space where the current instance is.
sys.dm_os_volume_stats will only give drives where database_files are located.