Home Forums SQL Server 2005 Administering Deleting the tables which are not been used from long time. RE: Deleting the tables which are not been used from long time.

  • Sean Lange (10/10/2012)


    Be careful with approach. Deleting tables just because they haven't been used in a couple months can very likely come back to bite you. What about reports that are only run once a year or other types of similar processes that are very important but not frequent?

    Definitely this.

    I would not be comfortable with this anywhere near DR.

    If the worst happens and you need to recover its much better to find you have recoverred something you no longer need than to find that vital piece of data used for e.g. your annual tax return is missing.

    By all means check through your databases to identify items which are no longer needed but dont mix this up with disaster recovery.