• Thanks Ninja. So as you and John suggested the final settings on SQL 2000

    autogrowth=Yes

    In Megabytes 500-2000

    Unrestricted file growth = Yes

    monitor using sp_spaceused or via scipt and keep doing what we're doing with the backups.