Viewing 4 posts - 1 through 4 (of 4 total)
.
June 5, 2024 at 5:03 pm
I know... but do you want to keep shrinking and expanding the transaction logs constantly? The backup to NUL is done against the databases with full recovery mode; I do...
March 31, 2023 at 2:19 pm
I know... but do you want to keep shrinking and expanding the log file constantly?... I do this in production where I have some databases that are replicated, and I...
March 31, 2023 at 1:05 pm
Another approach is to back it up to NUL
CHECKPOINT
BACKUP LOG [databasename] TO DISK = 'NUL'
March 31, 2023 at 12:19 pm
Viewing 4 posts - 1 through 4 (of 4 total)