<div>
Hello,<br />
<br />
Is this for the built in SQL databases used by SBS 2011 (I.E. SBSMONITORING etc) or have you installed another SQL Server Instance that needs an individual backup?<br />
<br />
By default the built in SBS Backup will take an image of the server so the SQL Databases will get backed up this way.<br />
<br />
Have a look here to backup SQL Manually using a script and scheduled tasks:<br />
<a href="http://blog.zwiegnet.com/windows-server/backup-sql-server-express-2008r2/" rel="ugc">http://blog.zwiegnet.com/windows-server/backup-sql-server-express-2008r2/</a>
</div>


<div>
Hi Scorpeo,<br />
<br />
Its for a another installed instance that needs an individual backups.<br />
<br />
So the link you posted will give me all the info I need?<br />
<br />
Thanks for your time<br />
Regards
</div>


<div>
Yes I believe so. &nbsp;<br />
<br />
I have not tested it myself though
</div>


<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I am trying to find our how to set up automated backups for a database we have on our SBS2011 server. I'm a bit confused because I know SQL Express wont allow automated backups, but I cannot see any reference to it being the express version on the server, yet the maintenance folder is clear not available.<br />
<br />
Could someone please point us is the right direction?<br />
Regards
</div>
</div>


Hi guys,

I am trying to find our how to set up automated backups for a database we have on our SBS2011 server. I'm a bit confused because I know SQL Express wont allow automated backups, but I cannot see any reference to it being the express version on the server, yet the maintenance folder is clear not available.

Could someone please point us is the right direction?
Regards

Hello,

Is this for the built in SQL databases used by SBS 2011 (I.E. SBSMONITORING etc) or have you installed another SQL Server Instance that needs an individual backup?

By default the built in SBS Backup will take an image of the server so the SQL Databases will get backed up this way.

Have a look here to backup SQL Manually using a script and scheduled tasks:
http://blog.zwiegnet.com/windows-server/backup-sql-server-express-2008r2/

Hi Scorpeo,

Its for a another installed instance that needs an individual backups.

So the link you posted will give me all the info I need?

Thanks for your time
Regards

Yes I believe so.  

I have not tested it myself though

Help with SBS2011/SQL2008 R2 Backups

Hi guys,

I am trying to find our how to set up automated backups for a database we have on our SBS2011 server. I&#39;m a bit confused because I know SQL Express wont allow automated backups, but I cannot see any reference to it being the express version on the server, yet the maintenance folder is clear not available.

Could someone please point us is the right direction?
Regards

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).