Automatic SQL backu in SBS2011

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
realtimerAsked:
Who is Participating?
 
donnkCommented:
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
 
Gregory MillerGeneral ManagerCommented:
Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.
0
 
WORKS2011Austin Tech CompanyCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.