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.

[AdrianAska-yi]

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

[jasonliang]

Wonderfully explained. Thanks for the explanation.

[GeraldOSullivan]

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

[rutwik_]

Basic SQL version don't have maintance plan?

I don't see maintainace plan option in management section

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

[haazimali]

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

[Mohammed-yjzt]

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