Community

SQL Server Script to Determine Free Space Prior to SQL Server Backup

(Eli Leiba) We need to create a simple piece of T-SQL code that will pre-check the free disk drive space and estimate the database backup size to determine if there is enough space to run the BACKUP DATABASE statement for the selected disk drive.