Schedule Backups of SQL Server 2012 (Not Express)

Posted on 2014-08-25
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

    Utilize the Maintenance Plan Wizard to schedule backups -

    Author Comment

    by:Bob Schneider
    I may not have express but I don't have that 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
    Maintenance Plan Wizard is part of SQL Management Studio which is included with all non-express versions of SQL. Example backup setup -
    LVL 4

    Assisted Solution

    by:Randy Knight, MCM
    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

    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
    Wow!!!  So much help.  Thanks!!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now