<div>
Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.
</div>


Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
<br />
I am running Small Business Server 2011. &nbsp;We are using a piece of software that runs off &nbsp;SQL (SQL Server 2008R2).<br />
<br />
<br />
I'm currently having to backup a database via the Microsoft SQL Server Management Studio.<br />
<br />
<br />
To do this I follow these steps:<br />
<br />
•Open Microsoft SQL Server Management Studio<br />
•Select ServerName | Databases | DatabaseName<br />
•Right-click | Tasks | Back-up<br />
•Establish path for destination backup file | Click OK<br />
<br />
Is there a means of setting up this process to be automated? &nbsp;<br />
<br />
<br />
Thanks in advance.<br />
<br />
<br />
Regards,<br />
<br />
Real-Timer
</div>
</div>


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

Automatic SQL backu in SBS2011

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).