Link to home
Start Free TrialLog in
Avatar of ghco
ghco

asked on

SQL 2012 database table purged

Dear All,

We have SQL 2012 and one table mysteriously have its data that older than 3 months purged. Is there any best way to find out what may caused this?

Thanks,
Avatar of Naitik Gamit
Naitik Gamit
Flag of India image

look at this link for different methods and explanations:

http://sqlmag.com/database-administration/4-ways-purge-non-partitioned-data
Do you know when was the last time the table had all data?
use the free https://www.red-gate.com/products/sql-development/sql-search/ and search for your table name. you might find a stored procedure purging data
Avatar of ghco
ghco

ASKER

I didn't really check when it had all data, but the latest data is 14/01/2015 which is a about exactly 3 months ago which make me think that there is a purge for all data that is older than 3 months.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial