Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating a Backup job!! Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 12:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, January 30, 2008 6:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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
Posted Wednesday, January 30, 2008 7:55 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:23 AM
Points: 318, Visits: 351
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
Posted Wednesday, January 30, 2008 8:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, January 30, 2008 8:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:38 AM
Points: 33,267, Visits: 15,436
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 »

Add to briefcase

Permissions Expand / Collapse