Solved

Automatic SQL backu in SBS2011

Posted on 2013-12-31
3
233 Views
Last Modified: 2014-01-14
Hello,


I am running Small Business Server 2011.  We are using a piece of software that runs off  SQL (SQL Server 2008R2).


I'm currently having to backup a database via the Microsoft SQL Server Management Studio.


To do this I follow these steps:

•Open Microsoft SQL Server Management Studio
•Select ServerName | Databases | DatabaseName
•Right-click | Tasks | Back-up
•Establish path for destination backup file | Click OK

Is there a means of setting up this process to be automated?  


Thanks in advance.


Regards,

Real-Timer
0
Comment
Question by:realtimer
3 Comments
 
LVL 11

Expert Comment

by:Technodweeb
Comment Utility
Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.
0
 
LVL 17

Assisted Solution

by:WORKS2011
WORKS2011 earned 250 total points
Comment Utility
I'm currently having to backup a database via the Microsoft SQL Server Management Studio.
to clarify you're running 'express' correct? Express can't be automated within itself.

You configure it using a batch file or .sql file, it may be better to install a 3rd party app there are plenty for $60 - $80.
0
 
LVL 6

Accepted Solution

by:
donnk earned 250 total points
Comment Utility
As long as your using SBS backup there is no need to do a separate sql one as well.

SBS is bare metal so you have everything.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

743 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

15 Experts available now in Live!

Get 1:1 Help Now