Automatic SQL backu in SBS2011
Posted on 2013-12-31
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.