On 28/05/2010 17:26, ginger wrote:
> I am not a sqlDBA, I want to find out how old the database dated? We want to
> keep 3 years Data on a sql box but I am not sure it is 3 years or 5 years of
> the database for now.
>
> How to clean up database , only keep 3 years data and get rid of older than
> 3 year?
>
> Someone told me to use DTS tool but I am not a DBA so I am not sure how to
> do it but I am eager to learn and practice on a test DB.
You'd be better off asking this in microsoft.public.sqlserver.server.
Unless the tables include date created/date modified columns (or similar
timestamps) that are updated by the application using the database, I
don't think there's any way of finding out how old the data is on a
row-by-row basis. I could be wrong though.
--
Chris M.
|