Home Forums SQL Server 2016 SQL Server 2016 - Administration Data Copy for reporting purposes RE: Data Copy for reporting purposes

  • February 12, 2018 at 11:15 am

    #1979477

    bubby - Monday, February 12, 2018 11:02 AM

    Thanks for the reply, I am thinking to provision on SQL server and do the log shipping for those 5 databases needed for reporting purposes of my existing server. Then my only issue is the data is only kept for 1 year on my existing server.

    - I need to know How to proceed,
    - is there any way I can do the archive,

    Thanks

    Ah – are you asking for ways in which to remove data which is > 12 months old?
    There's nothing built in ... you'll have to write your own script to do this (and that will depend on all of your tables having CreatedDate and ModifiedDate columns). Do you really mean archive, or just delete? (Because what's the point of archiving source data which already exists in your main database?)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.