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,
Microsoft SQL Server

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Naitik Gamit

look at this link for different methods and explanations:

http://sqlmag.com/database-administration/4-ways-purge-non-partitioned-data
Vitor Montalvão

Do you know when was the last time the table had all data?
Éric Moreau

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
Your help has saved me hundreds of hours of internet surfing.
fblack61
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
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.