Post reply

How to change the data retention period from 5 yr to 20yrs in SQL 2005

  • March 1, 2013 at 9:34 am

    #290142

    hi guys

    I am working on one scenario to figure out How to change the data retention period from 5 yr to 20yrs in SQL 2005.

    when this server was setup the retention period was set up by someone to 5 yrs but this year they want to change it to 20yr so how to do ?

    Any ideas?

    Thanks for Great Help.

  • March 1, 2013 at 10:23 am

    #1592474

    What do you mean by 'retention period'? SQL Server has no automatic purging or data retention features (except around job history and the like)

    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

  • March 1, 2013 at 10:36 am

    #1592481

    Data Retention is a business rule around specific processes that have been created for your data. How to change that retention period will depend on how the process was implemented.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 1, 2013 at 1:49 pm

    #1592561

    Possibly you have some custom job/script running on the server that you may have to look into...;-)

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

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

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