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 |
|
shohan_db
Starting Member
36 Posts |
 Posted - 2010-11-08 : 06:35:41
|
| Dear allI am using SQL SERVER 2000 for preserving my business data,Last few days I saw some exception with my database.1. the mdf file size of my database was 4.2GB in few days ago but with in few hours it grown up to 7.31GB. This is quite impossible for my database because it takes two years to build up 4.2GB and there are not any changes made in database that cause database grown up to 7.31 with in few hours!!!2. I am taking full backup and generally backup size is 1 GB but sometimes it shows 4/5GB. When this situation arrives I just wait for few minutes and then take again full backup and problem solve automatically.I don’t have any idea that why database is acting like that! Will those cause any problem in database?Please describe & advice me what to do?RegardsShohanshohan |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-11-08 : 11:05:42
|
| Would you be able to post some information about the application? Are there any processes using temporary tables within the database itself?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shohan_db
Starting Member
36 Posts |
Posted - 2010-11-22 : 01:14:50
|
| Sorry for late & thanks for reply.......jackv... yes there are some temporary tables and store procedures are populating/ inserting data into it.tkizer... No there is no maintenance plan.but my question if the db size increase 4 gb in a day... why it become small again...shohan |
|
|
|
|
|
|
unexpected DB size