Wednesday, December 18, 2002
After losing a battle to correct the database in BrightStor, I deleted it with extreme prejudice. Then we added an external drive stack with dual 4gb drives, and I am now reinstalling the database - putting the database on one of the new drives, the indexes on the other, and the transaction log and backup system on the original drive. This is the configuration recommended by BrightStor, so we have high hopes. If need be, I can extend the database once on the original drive, leaving 3.5gb (or so). I will still be restricted to using differential backups due to the high number of files per backup (800k per full backup), but with proper prune/purge settings, we should be OK. Of course, I have thought that before.