Database maintanence plan
Posted on 2006-11-21
I have a database maintenance plan that reorganizes data & index pages, changes free space per page percentage to 10%, removes unused space from database files and shrinks database when it goes beyond 50mb. (db is 5gb - not sure if this should change to 6gb rather than 50mb?)
When this runs from time to time (3:00AM) the websites using the database throw errors until this completes - upwards of 2 hours.
Is there any other way to run this? Break it up at all? I would rather not turn it off.