About
Pricing
Community
Teams
Start Free Trial
Log in
ghco
asked on
4/17/2015
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
5
1
Last Comment
Vitor Montalvão
8/22/2022 - Mon
Naitik Gamit
4/17/2015
look at this link for different methods and explanations:
http://sqlmag.com/database-administration/4-ways-purge-non-partitioned-data
Vitor Montalvão
4/17/2015
Do you know when was the last time the table had all data?
Éric Moreau
4/17/2015
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
4/17/2015
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
4/17/2015
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.
http://sqlmag.com/database-administration/4-ways-purge-non-partitioned-data