Re: Best way of tidying up the database

In article <34d87332.1036747727@news.demon.co.uk>, ian@tubeway- army.demon.co.uk says... > 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!! :-) Why not do the update statistics before the backup ?? > 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? 8. Run the update statistics on your tables but you knew that already didnt you :) denzil