Home Forums SQL Server 2008 SQL Server 2008 Administration Will using a Temp table as working / staging tables reduce the log backup size? RE: Will using a Temp table as working / staging tables reduce the log backup size?
steveb.
SSC-Forever
Points: 46733
More actions
July 24, 2013 at 4:12 am
#1635273
rather than put more work on the tempDb, you could create them a dedicated Staging Database and put this in simple mode so that log backups are not needed.