Link to home
Start Free TrialLog in
Avatar of realtimer
realtimer

asked on

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
Avatar of Gregory Miller
Gregory Miller
Flag of United States of America image

Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.
SOLUTION
Avatar of WORKS2020
WORKS2020
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial