Database files keep changing???

Question

Post reply

Database files keep changing???

timster

Ten Centuries

Points: 1033
More actions
September 5, 2008 at 8:10 am

#197812

Hey
I seem to have a problem when i try to increase initial size of the database files by 2GB it executes and then i check and all is well with the sizes... but i'll check again in 20min and the file sizes return to there original size
what can i do to fix this???

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 1

Do you have the AutoShrink option switched on for the database?

Kyle Neier , SSCrazy Points: 2252 More actions · Answer 2

I suspect that the database has "Auto Shrink" turned on.

Run this:

ALTER DATABASE [DBNAME] SET AUTO_SHRINK OFF and see if it still happens.

timster Ten Centuries Points: 1033 More actions · Answer 3

Auto shrink is set to false! and still happening

i cant understand this?? can you say wierd:D

Kyle Neier , SSCrazy Points: 2252 More actions · Answer 4

Does it happen regularly (is it ALWAYS 20 minutes)? It could be a SQL Agent job? AutoShrink runs every 30 minutes, so that is why it was an immediate first guess.

You can put a profile trace on the server, filter the TextData column for %SHRINK% . Make certain that login, host name, application, and database name are in your data column list. That should tell you where the shrink is coming from.

Kyle

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

what version sql server are you using?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

timster Ten Centuries Points: 1033 More actions · Answer 6

SQL 2005 Enterprize edition!!

Iv tried everything mentioned in this here forum thingie its happening..

GSquared SSC Guru Points: 260824 More actions · Answer 7

Check your log files in a log parser (ApexSQL has one of those, so does Lumigent). The shrink file command should be in there, and it will have data on where the command is coming from.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

Run a trace. There must be some shrink command being run.