I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA.
The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to growth unrestricted by 10%. I have lots of disk space - so thought it would be better to set the initial size to be considerably bigger. It is growing quickly - doubling in size in about the last 6 months.
Can I just pick a a high number (since I have plenty of space), and simply change the Initial Size (perhaps to 4,000 or something) - and then set it as a weekly check to make sure we are not within some percent of this number?
Thanks.