Steps for maintenence plan

Question

Post reply

Steps for maintenence plan

Saggy

SSCrazy

Points: 2003
More actions
April 11, 2012 at 11:57 am

#391991

hi....guys...
we have to create a nightly maintenance plan for the database Adventureworks that does:
1) Full database and transaction log backup
2) Integrity check, rebuild index, recompute statistics.
Backups should go to the E: drive on Adventureworks . Backups should be kept for 7 days and then be deleted.
what steps should be taken or we have to create a maintenance plan in so we have to flow throw steps or we have to create different jobs
reply asap..... thnx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 1

Yes, maintenance plan would work.....there are some nice videos in youtube which shows how to create it.

Regards,
SQLisAwe5oMe.

Jared SSC Guru Points: 61793 More actions · Answer 2

Saggy (4/11/2012)
hi....guys...
we have to create a nightly maintenance plan for the database Adventureworks that does:
1) Full database and transaction log backup
2) Integrity check, rebuild index, recompute statistics.
Backups should go to the E: drive on Adventureworks . Backups should be kept for 7 days and then be deleted.
what steps should be taken or we have to create a maintenance plan in so we have to flow throw steps or we have to create different jobs
reply asap..... thnx

"We" meaning students? Why would you be creating a nightly maintenance plan for AdventureWorks?

Jared
CE - Microsoft

CapnHector SSCoach Points: 16143 More actions · Answer 3

SQLKnowItAll (4/11/2012)
Saggy (4/11/2012)
hi....guys...
we have to create a nightly maintenance plan for the database Adventureworks that does:
1) Full database and transaction log backup
2) Integrity check, rebuild index, recompute statistics.
Backups should go to the E: drive on Adventureworks . Backups should be kept for 7 days and then be deleted.
what steps should be taken or we have to create a maintenance plan in so we have to flow throw steps or we have to create different jobs
reply asap..... thnx
"We" meaning students? Why would you be creating a nightly maintenance plan for AdventureWorks?

home work assignment??

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Jared SSC Guru Points: 61793 More actions · Answer 4

We will gladly help you if you run into issues. However, it is important that you at least try to develop this on your own first. Then when you run into a hurdle, post the specific issue here and we will talk you through it.

Jared
CE - Microsoft