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.