May 2, 2005 at 4:30 pm
I have several databases on MS SQL 2000 Server and all of them setup for unrestricted file grow with 10% increment. All of them, but one, behave as "doctor ordered". The "black sheep" database doesn’t grow automatically. The applications communicating with this database spit out the error: "failed to insert data into database". And as soon as I add some free space for the data file manually an error goes away. Any suggestions…
May 3, 2005 at 12:28 am
run sp_helpfile and make sure that your maxsize either hasn't been reached or isn't set
you may need to run sp_updatestats first to make sure your database sizes are correct.
Julian Kuiters
juliankuiters.id.au
May 4, 2005 at 10:04 am
'autogrowth' is both a blessing and a curse. A blessing to those who do not monitor database size and growth patterns and a curse to those who depend on it. I have run across occasions where the 'autogrowth' did not occur fast enough and encountered the exact situation that you are having. Aside from running out of physical disk (a very real possibility) you are fragmenting things terribly. Also performance takes a hit when 'autogrow' is occurring as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply