Solved

Automatic SQL backu in SBS2011

Posted on 2013-12-31
3
238 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39749402
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
ID: 39750094
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
ID: 39751063
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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

726 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