DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans

Developers and sysadmins: the easiest way for you to protect your servers is by using maintenance plans. Full time production database administrators should watch the Ola Hallengren maintenance script setup module instead. I'm specifically targeting this video at developers and sysadmins who need an easy, safe way to protect stuff without knowing T-SQL.

[@user-fe8tg6up2g]

This guy is great for my low attention span. Thank you so much!

[@BrentOzarUnlimited]

You're welcome!

[@GeraldOSullivan]

Excellent. Nice combination of good advice and practicality. Good work!

[@BrentOzarUnlimited]

Glad you enjoyed it!

[@jasonliang9114]

Wonderfully explained. Thanks for the explanation.

[@steveabba8463]

Thanks Brent!!!

[@user-xp5sk8ts3q]

Thank you!

[@reyamcarias8202]

Thanks brent

[@UB764]

Legend

[@TheMistervac]

Good basic guide. At 6:24 you said you didn't like to back up to a local drive and move it to a drive off the server. Yes, I agree, but this way is a bit risky. Why ? I explain with my example. I made backups directly to NAS QNAP and ZYXEL connected to the server using the iSCSI protocol. There were times when the NAS disconnected for various reasons. Then there was a problem with the lack of backup. Personally, I do it as you show, but first on a local drive. If the backup is completed correctly, the next step is to call Execute SQL Server Agent Job Task and in it call the created Jobs with the command (Operating system CmdExec) xcopy /S /C /V /Y D:\BACKUP F:\BACKUP where D: local disk of the server and QNAP mapped as F. I have one more of the same task but I am copying the backup to ZYXEL. In the e-mail notification, I have set that in case of problems with backup, cleaning old files or copying, I get an e-mail. Then I check what the problem is. This way I always have at least one good backup.
Plus, I do a SNAP every few hours. All the best.

[@BrentOzarUnlimited]

I didn't say iSCSI: I said network shares.

[@TheMistervac]

@@BrentOzarUnlimited Ok, I also have a Xtreamer e-TRAYz NAS connected via SMB. This one disappears quite often, so it's not credible to me. So, I prefer local disk first and then NAS.

[@BrentOzarUnlimited]

@@TheMistervac Given that SQL Server Standard Edition costs $2,000 USD per CPU core, most folks use something more reliable. You're not pirating SQL Server, are you?

[@TheMistervac]

@@BrentOzarUnlimited I only use licensed software. 😀SQL standard is for 2 cores.

[@BrentOzarUnlimited]

@@TheMistervac Incorrect: the minimum number of cores for licensing is 4. They're sold in 2-packs only so that you can use, say, 6 cores. Read the Microsoft SQL Server licensing guide.

[@haazimali489]

You cover setting up full database backups and log backups but don't mention differential backups. Why?

[@BrentOzarUnlimited]

Because I can't cover every topic in every video. ;-)

[@CodeXploit]

Hallengreen or bust...

[@162900443]

Hmmm... who is bust?

[@CodeXploit]

@@162900443 Anyone who is not using Halengreen 😉

[@lucianavasiloiei7864]

Thank you!

[@BrentOzarUnlimited]

You're welcome!