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.

 

Next

Post your questions, comments, feedbacks and suggestions

Contact a consultant

Related Topics


 

 


 

 

Hit Counter   This web is provided "AS IS" with no warranties.
Copyright © 2002-2018 ChicagoTech.net, All rights reserved. Unauthorized reproduction forbidden.