In SSMS, if you right-click on the SQL Server Logs in the Management section, you can limit the number of log files before they get recycled.  Note, though, that the...

• This reply was modified 5 years, 11 months ago by jasona.work. Reason: Added some detail

This right here would be the problem...

The...

I'll easily grant there have been moments in the current round of SW movies that have been...

Questionable and lead to WTF moments if you try to think too hard about...

Because where you're setting it will be tracking the information in the SQL Logs, rather than a separate log (such as using SQL Audit in Enterprise edition,) you'd have to...

Dang, it got quiet around here again.

Not surprising with XMas a week away, I guess, so to those of you who celebrate the holiday, happy holidays!

Anyone got plans to see...

So a couple thoughts on this.

First, STOP doing the backup log to NUL, it'll kill your log chain if you ever need to recover.

Second, yes, step up the frequency of...

Well the more I thought about it after I posted, the more I realized that if SSRS...

From what you've described, I'm 99% sure you'd be able to go in and remove everything except SSRS without impacting SSRS.  You might need to reboot at the end of...

I have actually received that as an answer...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and /...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...

🙂

Jeff, I did miss that second part, so my apologies. So you're suggesting shrinking it to 0 to clear up any fragmentation issues, then resize it to the 2gb...

To be clear, please reread.  I've NOT suggested letting it automatically grow from zero anywhere in my recommendations.  I explicitly stated that for this database, I'd regrow it to...

• This reply was modified 5 years, 12 months ago by jasona.work.

I'm with Jeff on your analysis, but not on his suggestion on tackling the Transaction Log (not completely, at least!)

I'd still go with the shrink the size to 0 (not...

• This reply was modified 5 years, 12 months ago by jasona.work. Reason: Saw Jeff's second post, now I'm with him