Best way of tidying up the database
Posted in 1998
Hi All, I was considering a tidy up operation on our database. In the years that it has been up and running it has never been properly maintained in order for it to be as efficient as possible. In fact, I modified the backup script the other night to include an 'UPDATE STATISTICS' afterwards and that is probably the only administration that it has seen in 5 years!! :-) My plan for giving the database an overhaul was as follows: 1. Backup the database. 2. Backup the database. Never can be too carful :-) 3. Produce a schema from which to re-create the database. 4. Unload the data for each table to an ascii file. 5. Delete the database. 6. Recreate the database from the schema. 7. Load all the data back. Sounds straightforward enough. Am I missing anything? Any views/comments would be most welcome. Cheers, Ian. Tedious 'office speak' part 3: "Let's go scuba in the think tank."