How to see SQL database date

Discussion in 'Server Security' started by ginger, May 28, 2010.

  1. ginger

    ginger Guest

    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.
     
    ginger, May 28, 2010
    #1
    1. Advertisements

  2. ginger

    Chris M Guest

    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, May 31, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.