Home Forums SQL Server 2005 Backups recover old data RE: recover old data

  • January 17, 2013 at 12:53 am

    #1578123

    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.