DBA Fundamentals - Backups 3 - Setting Up Maintenance Plans

[@AdrianAska-y5i]

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.

[@rutwik_1200]

Basic SQL version don't have maintance plan? I don't see maintainace plan option in management section

[@Mohammed-yj1zt]

when we should use SQL Agent and when Maintenance plans? I'm confuse because of I heard someone says sql agent better than maintenance and he moved to it instead of the maintenance

[@BrentOzarUnlimited]

The person who told you Agent jobs are different than maintanence plans didn't do a good job of explaining. Agent is the thing that handles scheduling. Agent calls maintenance plans AND scripts.

[@Mohammed-yj1zt]

@@BrentOzarUnlimited thank you so much

[@YvdB]

Can I asume that the azure edition works the same as enterprise edition?

[@BrentOzarUnlimited]

No, I have a separate class for Running SQL Server in Azure & AWS.

[@UB764]

Legend

[@Ренат-ц8ж]

Thank you!

[@steveabba8463]

Thanks Brent!!!

[@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. ;-)

[@reyamcarias8202]

Thanks brent

[@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.

[@CodeXploit]

Hallengreen or bust...

[@162900443]

Hmmm... who is bust?

[@CodeXploit]

@@162900443 Anyone who is not using Halengreen 😉

[@YvdB]

In europe we take 3 week holidays. Should we keep 4 weeks of backups?

[@BrentOzarUnlimited]

For customized answers based on your own production scenarios, feel free to contact me for consulting.

[@lucianavasiloiei7864]

Thank you!

[@BrentOzarUnlimited]

You're welcome!