Twitter | Search | |
Brent Ozar
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
95,992
Tweets
509
Following
24,400
Followers
Tweets
Brent Ozar 2h
Today’s project: configurable folder names for Ola’s backup scripts: Feedback welcome, code in there too.
Reply Retweet Like
Brent Ozar 2h
Replying to @SirSQL
Yep. I’m curious to see if you get further than I did, hahaha. Spent like a day on that on 2016 and was stumped.
Reply Retweet Like
Brent Ozar 2h
Replying to @SirSQL
At first, thought it was log file prep, but that’s not it either.
Reply Retweet Like
Brent Ozar 2h
Replying to @SirSQL @50
Yep. Exact same thing happened with me pretty consistently. Really strange. Ran out of time getting to root cause and had to give up.
Reply Retweet Like
Brent Ozar 2h
Replying to @SirSQL
Like with 20+ files, I could get it to happen at around 80-90% of the process timeline instead of around 50%.
Reply Retweet Like
Brent Ozar 2h
Replying to @SirSQL
What’s really interesting is that if you use more backup files, the step down happens later in the process. Tested up to 20 files.
Reply Retweet Like
Brent Ozar 2h
Replying to @stuben32
Yeah, found it in testing changes to Ola’s scripts. Went to test it on Standard and went, “Well, whaddya know.”
Reply Retweet Like
Brent Ozar 2h
Replying to @BeginTry
I’ve never actually USED it, mind you, just…learned that today, hahaha.
Reply Retweet Like
Brent Ozar 3h
Today I learned that mirrored backups are an Enterprise Edition feature. Huh.
Reply Retweet Like
Brent Ozar 8h
Replying to @JRendon
I love that one too, heh, but it sounds cold.
Reply Retweet Like
Brent Ozar 8h
Replying to @dhmacher
I love that term. Always breaks the ice.
Reply Retweet Like
Brent Ozar 8h
Replying to @sqlstudent144
HA!
Reply Retweet Like
Brent Ozar 9h
We’re on a custom version of Enlighter now too, and it doesn’t highlight TSQL correctly. It’s on my honey-do list.
Reply Retweet Like
Brent Ozar 9h
Yeah, that was the problem, broke rendering on the site and we had to yank it. I miss it.
Reply Retweet Like
Brent Ozar 9h
Yeah, my problem was having to replace it all (twice) after plugin conflicts w/other plugins.
Reply Retweet Like
Brent Ozar 9h
It’s super-popular, but no, no active development. Lots of forks.
Reply Retweet Like
Brent Ozar 9h
Replying to @AdamMachanic
Even works for parts of the anatomy. Multiple parts.
Reply Retweet Like
Brent Ozar 9h
Henceforth, I shall refer to all of you as bone burritos.
Reply Retweet Like
Brent Ozar 9h
We used to use it, but switched without the T-SQL formatting. That would be nice for you to share, heh.
Reply Retweet Like
Brent Ozar 10h
Replying to @Pittfurg @GFritchey
Ooo, neat, will check that out. No updates in a year worry me though.
Reply Retweet Like