Thank you so much for this. I messaged you on Tuesday to ask about this course and you said it was no longer offered. Now you released it for free on youtube. Thanks a lot man!
Brent thanks very much for this content. And thanks also for your personality! Watching and listening to you always puts a smile on my face, the teacher really does make a difference even if the information isn't super fun to learn about.
My issue with snapshot backups are that they remove a lot of the oversight and management from the DBA. Things can come up like the backups randomly breaking and the backup administrator spins their wheels for days trying to figure it out with there are no backups. It really spreads out the responsibility for backups, to extend to the VMware administrator, the storage administrator, usually someone from systems and when there is a problem in any one of those four areas, it can create backup problems that all of them are required to work together on, and four different areas that can break the backups. have also had backup admins decide to start backing up windows on a SQL server which normally wouldn't be an issue but when the backup server and backup storage is getting hammered with however many other backups are, windows may get frozen for an extended period. This is really fun when it happens to multiple nodes in the failover cluster, you lose quorum and then it spends a few minutes figuring out whos on first, whats on second. Veeam specifically has made backups really easy to manage so that lots of organizations will put someone on who doesn't understand backups, vss, the applications being backed up, etc and when there is a problem can't resolve it. Bugs and managing updates are also a somewhat common problem, veeam seems to have 1-2 per year that seriously impact performance, going back a few years ago they had a few bugs that would actually damage a server. I implemented snap protect once 7-8 years ago and it was fantastic, but the backups, and understanding sharepoint, exchange, SQL, AD et al well enough to understand what and why I was backing up what I was, was the job. Most of the places i have been the veeam backup guy didn't even know what a log file in SQL is, and was also usually responsible for supporting an entire other full time job while the backups were just supposed to work and not have problems that needed to be dealt with.
We don’t have a DBA, just me as a dev who knows a bit of SQL. They’re currently doing 4 daily backups per day and are refusing to switch to log or diff backups. Madness.
So I know this an old class, but as far as Snapshot backups, they don't truncate the log file if the database is in full recovery model after the snapshot, you have to run native SQL log backups for that, no?
@@BrentOzarUnlimited Great to hear this! I'm coming from Data Engineering background, especially working in Azure and I want to expand my knowledge. Thanks for creating these videos.
Thank you so much for this. I messaged you on Tuesday to ask about this course and you said it was no longer offered. Now you released it for free on youtube. Thanks a lot man!
You are so welcome!
Brent thanks very much for this content. And thanks also for your personality! Watching and listening to you always puts a smile on my face, the teacher really does make a difference even if the information isn't super fun to learn about.
My pleasure!
OH wow. Just found out this is now free. Thank you so very much!
Thanks a million for releasing this course for free!!
Glad you like it!
My issue with snapshot backups are that they remove a lot of the oversight and management from the DBA. Things can come up like the backups randomly breaking and the backup administrator spins their wheels for days trying to figure it out with there are no backups. It really spreads out the responsibility for backups, to extend to the VMware administrator, the storage administrator, usually someone from systems and when there is a problem in any one of those four areas, it can create backup problems that all of them are required to work together on, and four different areas that can break the backups. have also had backup admins decide to start backing up windows on a SQL server which normally wouldn't be an issue but when the backup server and backup storage is getting hammered with however many other backups are, windows may get frozen for an extended period. This is really fun when it happens to multiple nodes in the failover cluster, you lose quorum and then it spends a few minutes figuring out whos on first, whats on second.
Veeam specifically has made backups really easy to manage so that lots of organizations will put someone on who doesn't understand backups, vss, the applications being backed up, etc and when there is a problem can't resolve it. Bugs and managing updates are also a somewhat common problem, veeam seems to have 1-2 per year that seriously impact performance, going back a few years ago they had a few bugs that would actually damage a server.
I implemented snap protect once 7-8 years ago and it was fantastic, but the backups, and understanding sharepoint, exchange, SQL, AD et al well enough to understand what and why I was backing up what I was, was the job. Most of the places i have been the veeam backup guy didn't even know what a log file in SQL is, and was also usually responsible for supporting an entire other full time job while the backups were just supposed to work and not have problems that needed to be dealt with.
Thank you, sir!
damn you know your stuff
I got a lot of scars from this work, for sure...
Thanks Brent! How about taking full native SQL backup along with periodic differential backups for simple recovery configured databases?
Differentials are outside of the scope of this course.
nice video
I'm glad you like it
We don’t have a DBA, just me as a dev who knows a bit of SQL. They’re currently doing 4 daily backups per day and are refusing to switch to log or diff backups. Madness.
So I know this an old class, but as far as Snapshot backups, they don't truncate the log file if the database is in full recovery model after the snapshot, you have to run native SQL log backups for that, no?
If you don't intend to do log backups, you can just use simple recovery model.
Hey Brent, Would it be possible to get access to the slides for "Fundamentals of Database Administration"?
No.
Is knowledge from this course still up to date?
Yep!
@@BrentOzarUnlimited Great to hear this! I'm coming from Data Engineering background, especially working in Azure and I want to expand my knowledge. Thanks for creating these videos.
@@BrentOzarUnlimited from which video should I start to start from fundamentals? This one?
@@TheMapleSight I can't do personal training for free here in the comments, but feel free to check out the channel. Cheers!
Databases are more critical then emails
You know the saying : Real men don't do backups, but they cry a lot.