DotNetShoutout - Schedule database backup for sql server 2005 using maintenance plan

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

4
Shouts

Shout it

Schedule database backup for sql server 2005 using maintenance plan

posted by

kcherupa 811 days, 15 hours, 52 minutes ago

Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that.

Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard.
Follow the wizard
In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i...

category: SQL | clicked: 0 | | source: cherupally.blogspot.com

| show counter code

tags: sql agent, recurrent, backup, Database, SQL Server 2005, Daily

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout