Skip to main content
Database Administrators

Return to Answer

added 56 characters in body
Source Link
David Browne - Microsoft
David Browne - Microsoft
  • 49.2k
  • 3
  • 53
  • 102

what would be the impact in a scenario where the file is already huge AND regular log backups are taken AND it is only filled for max 10% or so.

Not much.

TheAFAIK, yhe only impacts are wasted space, and the inability to RESTORE the database on a server without so much disk space, and the big log file will have to be zero'd on RESTORE.

what would be the impact in a scenario where the file is already huge AND regular log backups are taken AND it is only filled for max 10% or so.

Not much.

The only impacts are wasted space, and the inability to RESTORE the database on a server without so much disk space.

what would be the impact in a scenario where the file is already huge AND regular log backups are taken AND it is only filled for max 10% or so.

Not much.

AFAIK, yhe only impacts are wasted space, the inability to RESTORE the database on a server without so much disk space, and the big log file will have to be zero'd on RESTORE.

Source Link
David Browne - Microsoft
David Browne - Microsoft
  • 49.2k
  • 3
  • 53
  • 102

what would be the impact in a scenario where the file is already huge AND regular log backups are taken AND it is only filled for max 10% or so.

Not much.

The only impacts are wasted space, and the inability to RESTORE the database on a server without so much disk space.