Like what you see?

Menu

Articles in this section

See more

How to schedule a full backup of SQL databases Follow

Avatar
Dave White
  • Updated

Open Management Studio

Expand Management

Right-click Maintenance Plan

Choose Maintenance Plan wizard

 mceclip1.png

Click Next

 mceclip3.png

Name the Plan

mceclip4.png

Click Change

mceclip5.png

Decide on the schedule you want to use

Click OK

Click Next

mceclip6.png

Chose Full backup

mceclip7.png

Click Next

mceclip8.png

Click the dropdown next to databases

Chose all the databases you want to backup

Click Next

mceclip9.png

Click Finish

mceclip10.png

The plan you created will be on the left.

Click Close

 mceclip11.png

 

Related articles

Comments

0 comments

Please sign in to leave a comment.