Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Delete all archived projects except the latest archive? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello, the requirement I have is that all archive projects in the archive database be deleted except the last archive. The archive database is very large. Some of these files were archived 7 years ago, maybe older. Currently the archive db is in MPS2007 but I also have a 2010 version that I can work with. Ultimately the goal is to have small archive db in the 2010 format anyway.

    I know how to select and delete projects from a certain date and older, but I can't figure out how to delete all duplicate archives and leave just one behind, regardless of how old the archived files is.

    If anyone has a solution or suggestion, I could really use your input.

    Thank you for any help or comments.

    Monday, June 15, 2015 5:50 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello Quized again,

    Set the retention number for projects to be 1 and run the archive.  That way you should delete all of the copies, except the last one.  You may need to go through a SQL process to shrink the DB.

    Ben Howard [MVP] | web | blog | book | P2O

    Monday, June 15, 2015 8:22 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello Quized again,

    Set the retention number for projects to be 1 and run the archive.  That way you should delete all of the copies, except the last one.  You may need to go through a SQL process to shrink the DB.

    Ben Howard [MVP] | web | blog | book | P2O

    Monday, June 15, 2015 8:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you Ben. I'll give this a go and post back.

    Monday, June 15, 2015 9:03 PM