recover old data

  • Hi,

    can anyone help me how to recover the old data from SQL database? The data in the database only lasts for 3months. Pleaseeeeeee this is very urgent.

  • Where is the old data? Was it deleted? Was it moved to some other database or server before deleting?

    Restore the old backup as dbname_old. Then get the data from this db.

  • Do you have backups of your database?

    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

  • we do have backups but i'm not sure where to check why i can only see only the past 3months data.

  • the data supposed to be inside this one table. I just need the old data, from this particular table only.

  • fatinnadiah88 (1/17/2013)


    we do have backups but i'm not sure where to check why i can only see only the past 3months data.

    If you have a backup of the database, then you need to restore that backup. Restore it as a different database and then copy the data from the restored database into the production database.

    As per the 3 months of data - is there a purge process that is deleting everything older than 3 months?

    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

  • SQLRNNR (1/17/2013)


    fatinnadiah88 (1/17/2013)


    we do have backups but i'm not sure where to check why i can only see only the past 3months data.

    If you have a backup of the database, then you need to restore that backup. Restore it as a different database and then copy the data from the restored database into the production database.

    As per the 3 months of data - is there a purge process that is deleting everything older than 3 months?

    i dont think so. but if there's any, do you have any idea where can i check that? is it in the maintenance plan? or is there any other reason why?

    sorry im very very new in this.

  • It is possible that it would be in a maintenance plan. It is possible that it is being run through a 3rd party app. It is possible that there is a sql agent job running it. It is also possible that another person just run a tsql command for a 1-time backup.

    Here is a script that can help you get a history on the backups

    http://jasonbrimhall.info/2012/11/30/backup-history/

    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

Viewing 8 posts - 1 through 7 (of 7 total)

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