InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:36:30 GMT20http://www.sqlservercentral.com/Forums/Topic1401138-1550-1.aspx[quote][b]sreenubabu.s (12/28/2012)[/b][hr]i got below issue in the SQL Server 2005 log shippingLog Shipping Backup job has failing since 1 week with error message "Disk Space is not enough"i have checked Disk Free Space and Log file space but there is no issue with free space of DiskDisk Free Space:760 GBLog file (single log file) Used space is 91%It is Production Database, Database Size: 1 TBcan you please anyone tell me how to fix this issue ?[/quote]Please post the results of this query when run against your particular database[code="SQL"]SELECT df.name AS LogicalFileName , ISNULL(fg.name, 'Log') AS FilegroupName , physical_name AS PhysicalOSName , (df.size * 8 / 1024) AS SizeMBs , (FILEPROPERTY(df.name, 'SpaceUsed') / 128) AS SpaceUsedMBs , CASE df.growth WHEN 0 THEN 'No growth' ELSE 'Growth allowed' END AS GrowthAllowed , CASE WHEN df.max_size = -1 THEN 'Unlimited' WHEN df.max_size = 268435456 THEN '2TB' ELSE CAST(df.max_size / 128 AS VARCHAR(10)) + ' MBs' END AS GrowthStats , CASE df.is_percent_growth WHEN 0 THEN CAST(df.growth / 128 AS VARCHAR(10)) + ' MBs' ELSE CAST(df.growth AS VARCHAR(10)) + ' %' END AS Growth , (df.size * 8 / 1024) - (FILEPROPERTY(df.name, 'SpaceUsed') / 128) AS FreeMBsFROM sys.database_files df LEFT OUTER JOIN sys.filegroups fg ON df.data_space_id = fg.data_space_idORDER BY df.type[/code]Mon, 31 Dec 2012 01:42:57 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1401138-1550-1.aspxis 91% of the log file size greater than 760GB?Sun, 30 Dec 2012 05:56:15 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1401138-1550-1.aspxi got below issue in the SQL Server 2005 log shippingLog Shipping Backup job has failing since 1 week with error message "Disk Space is not enough"i have checked Disk Free Space and Log file space but there is no issue with free space of DiskDisk Free Space:760 GBLog file (single log file) Used space is 91%It is Production Database, Database Size: 1 TBcan you please anyone tell me how to fix this issue ?Fri, 28 Dec 2012 23:32:39 GMTsreenubabu.s