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
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
SBS
Last Comment
donnk
Yes, look under the Management folder and then Maintenance Plans. There you can create any number of scheduled maintenance tasks, including automated backups.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.