Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2011-01-14 : 23:40:40
|
| Hi guys,I moved a database from a client's site to my network and working on settting it up. But the data file is shrinking unexpectedly.. I’ve already deleted all the stuff they had in the database (stored procedures, striggers, functions, views, etc.). And one of the stored procedures would shrink the database. But it’s gone now, and the thing is still shrinking unexpectedly. This is going to cause “database full” problems if we don’t find it. For example, I increased the data files substantially, and they shrank again. I increased them again and they shrank again. This has likely caused me to waste 4 hours tonight….Any idea on why is this happening?Thanks in advance.- Shiyam |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-15 : 03:52:37
|
| Autoshrink is enabled or there's a job that's shrinking--Gail ShawSQL Server MVP |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-01-15 : 06:16:22
|
| Disable autoshrink and either do a trace or Activity Monitor - and gauge if there's a process creating this situationJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Data base shrinking