Creating a Backup job!!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Creating a Backup job!!

Creating a Backup job!!

Rate Topic

Display Mode

Topic Options

Author

Message

Disco-475330

Posted Tuesday, January 29, 2008 12:55 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2008 9:43 AM
Points: 13, Visits: 93

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.:)

Post #449062

free_mascot

Posted Wednesday, January 30, 2008 6:56 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768, Visits: 1,312

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."

Post #449355

KenpoDBA

Posted Wednesday, January 30, 2008 7:55 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:35 PM
Points: 314, Visits: 294

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.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com

Post #449399

Disco-475330

Posted Wednesday, January 30, 2008 8:18 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2008 9:43 AM
Points: 13, Visits: 93

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

Post #449431

Steve Jones - SSC Editor

Posted Wednesday, January 30, 2008 8:26 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #449445

« Prev Topic | Next Topic »

Permissions