Schedule Backups of SQL Server 2012 (Not Express)

Posted on 2014-08-25
Medium Priority
Last Modified: 2014-08-25
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?

Question by:Bob Schneider
LVL 14

Accepted Solution

Brad Groux earned 1000 total points
ID: 40283393
Utilize the Maintenance Plan Wizard to schedule backups - http://msdn.microsoft.com/en-us/library/ms191002.aspx

Author Comment

by:Bob Schneider
ID: 40283408
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.
LVL 14

Assisted Solution

by:Brad Groux
Brad Groux earned 1000 total points
ID: 40283434
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.


Assisted Solution

by:Randy Knight, MCM
Randy Knight, MCM earned 500 total points
ID: 40283635
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.


Assisted Solution

Ven_Aluri earned 500 total points
ID: 40283890
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

TO DISK='Path on Disk\Backupfull.bak',
With Format

Author Comment

by:Bob Schneider
ID: 40284245
Wow!!!  So much help.  Thanks!!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question