Creating a Backup job!!

Question

Creating a Backup job!!

Disco-475330

Old Hand

Points: 393
More actions
January 29, 2008 at 12:55 pm

#186019

Does anybody have an idea on how to create a job( for a list of tables) to backup any data older than 7 days to a backup table and clean up the backup table of any data older than 14 days? Any help would be highly appreciated.:)

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

You can design DTS package (SSIS) to do insert / delete operation and schedule DTS package.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 2

Y, those are pretty simple DML operations, so either create an SP and run it in a job, or paste the query text directly into the job, or create a package. It's pretty straight forward...

which part are you having trouble with?

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

Disco-475330 Old Hand Points: 393 More actions · Answer 3

having difficulty in SP or query to carry out this operation.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

You can also script this stuff out and then put it in to a job. SSIS might be overkill, depending on what you need.

Please show us some of what you've tried. What is difficult. We like to help, but we're not here to do all the work for you.