Post reply

How would dev go about purging data on a schedule?

  • March 9, 2010 at 6:25 am

    #216319

    The policy where I work is the development group owns the data and the DBA's just make sure it's available at all times (not uncommon, I know). That being said, there are tables that contain data that needs to be purged when it's older that 60 days.

    What should development do to purge the data?

  • March 9, 2010 at 6:28 am

    #1130594

    Write a stored proc that will do the purging, test that it doesn't kill the transaction log in the process, then go to whoever is responsible for scheduled jobs and ask them to schedule it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

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