We are on version 4.5B. We went live November of 1999. Our current database is 700GB+. We have 45 active retail shops (school and office supplies). Do you think the size of our production is normal?
It depends on what modules you have implemented. The database is large for sure. However, I am afraid I cannot judge if it's too large for what you have running. I do recommend you check if the application logs are cleaned up once in a while. Take a look at SAP note 195157 (Application log: Deletion of logs). Have you done any archiving, yet? As an SAP customer you are entitled to have them log in to your system and do a system check. They may be able to come up with sound recommendations as to what to do to keep the database at a decent size.
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila.
Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip.
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip.