Home Forums SQL Server 7,2000 Backups db autogrowth settings RE: db autogrowth settings
TJ-356724
SSC Eights!
Points: 964
More actions
January 10, 2012 at 7:21 am
#1431133
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.