What is the best way to schedule daily SQL 2008 R2 backups?

I would like to set up automated daily SQL 2008 R2 Server Backups of two SQL databases. What is the best way to accomplish this?
Who is Participating?
CboudrozConnect With a Mentor Commented:
use the maintenance plan wizard in SQL Server Management Studio

Aaron TomoskySD-WAN SimplifiedCommented:
Sqlcmd is a command line utility that can backup a db. Write a little batch file and run it using task scheduler.
kamindaConnect With a Mentor Commented:
With SQL Server's Maintenance plan wizard you can do this. It is highly recommended and the Agent Job log which you can monitor regularly. In that you can even setup deleting or archiving old backup files. It is really a great tool.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

as stated by ' Cboudroz' maintenance plan is the best option in my opinion.
PDSWSSAuthor Commented:
Thanks. Looks like the Maintenance Plan Wizard is the way to go.

How would I  change settings from Full Backup to Differential backup?
You can modify the actual maintenance plan and in the "Back Up Database Task" you can change the back up type from "Full" to "Diffential"

or in the Creation wizard it's the second tab "select maintenance plan tasks"  - check Differential

PDSWSSAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.