Disadvantage of data redundancy: Data redundancy increases the size of the database unnecessarily. It affects the consistency of data. It decreases efficiency of a database. The duplicate copy of data leads to confusion in updation and retrieval of data.