on 11-26-2014 9:34 AM
Hello, all
Database, which has only around 30M of actual data has grown to 800,000MB due to user error (500,000 rows were inserted into one table, and later deleted).
Is there a way to "compress" the DB file, so it would not take so much disk space without rebuilding the whole DB? I do not want to take the users off line for something that does not actually interfere with their work.
dbunload/reload is the way to 'shrink' a db.
http://dcx.sybase.com/index.html#sa160/en/dbadmin/dbunload.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You might try creating a High Availability setup with a brand-new secondary database created via unload/reload. Once the HA setup is running, and the slim secondary is up-to-date with respect to the bloated primary, stop the bloated primary database and let the slim secondary database become the primary.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.