Schedule Backups of SQL Server 2012 (Not Express)

Just did a manual back-up of my database.  Since it is not an "Express" shouldn't I be able to schedule backups?  If so, how do I do that?

Thanks!
Bob SchneiderCo-OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brad GrouxSenior Manager (Wintel Engineering)Commented:
Utilize the Maintenance Plan Wizard to schedule backups - http://msdn.microsoft.com/en-us/library/ms191002.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bob SchneiderCo-OwnerAuthor Commented:
I may not have express but I don't have that wizard...my Maintenance level only has Policy Management, Extended Events, and SQL Server Logs.

Oh, well.  Vale has a utility that I can use...unless you know of another one.
0
Brad GrouxSenior Manager (Wintel Engineering)Commented:
Maintenance Plan Wizard is part of SQL Management Studio which is included with all non-express versions of SQL. Example backup setup - http://msdn.microsoft.com/en-us/library/ms189953.aspx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Randy Knight, MCMPrincipal ConsultantCommented:
Another great option are Ola Hallengren's maintenance scripts.  Open source and very well supported and documented.  I have been using them for most of my customers for years.  And they will help you set up DBCCs, index maintenance, and more.  Based on your question I suspect you don't have other maintenance jobs set up either so this would be a good solution and learning resource.

Re: The SQL Server Maintenance Plan Wizard.  This is fine for very simple systems and databases, usually used by accidental DBA's or SysAdmins without a lot of DBA experience.  But most seasoned SQL Server DBAs stay away from them for a variety of reasons.

http://ola.hallengren.com
0
Ven_AluriCommented:
You can use Maintenance Plan to schedule backups. The other option is to schedule the scripts in SQL Server Agent.

Script can be something like

BACKUP DATABASE DBName
TO DISK='Path on Disk\Backupfull.bak',
With Format
Go
0
Bob SchneiderCo-OwnerAuthor Commented:
Wow!!!  So much help.  Thanks!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.