|
|
|||
Home | Troubleshooting | Quick Setup | Cisco How to | Data Recovery | Forums | Blog | IT Exam Practice | Services | About Us | Chicagotech MVP | Search | Contact Us | |
|
How to create SQL Database backup using Maintenance Plan
1. Login Microsoft SQL Server Management Studio. 2. Navigate to SQL Server name>Management, right click on Maintenance Plans, select SQL Server Maintenance Plan Wizard. Click Next to continue.
3. In the Select a Target Server, enter the backup name, select the SQL server and authentication.
4. In the Select Maintenance Tasks, select backup task.
5. In the Select Maintenance Task Order, click Next to continue.
6. In the Define Back Up Database (Full) Task., select the database you want to back up.
7. In the page, add the location the database will be backed up to.
Post your questions, comments, feedbacks and suggestions Related Topics
|
|
|
This web is provided "AS IS" with no warranties.
Copyright © 2002-2018
ChicagoTech.net,
All rights reserved. Unauthorized reproduction forbidden.