• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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
0
realtimer
Asked:
realtimer
2 Solutions
 
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
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now