Click here to Skip to main content
11,645,087 members (66,929 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server
Please help me ,my sql server database mdf file size increase from 10 gb to 157 gb suddenly .what are the reasons for increase of database mdf file size.i saw the table size there are normal.i want to know how the space is utilised for the sql server database.

EXEC sp_spaceused @updateusage = N'TRUE';

database name :-RMS
database size :-182032.00 MB
unallocated space :-149751.69 MB

Reserved 11584832 KB
data 11559248 KB
index_size 5432 KB
unused 20152 KB

my rms data is 11gb but rms mdf file size is 157 gb .what are the reasons for increasing of database mdf file size
Posted 6-Oct-13 19:18pm
Edited 6-Oct-13 20:46pm
Madhu Sasi Nair at 7-Oct-13 1:34am
This increase in size has been suddenly or over a period of time?
kalisiddayya at 7-Oct-13 1:53am
suddenly it is increase
kalisiddayya at 7-Oct-13 2:15am
i wont have 157 gb data in my sql server is increase suddenly.can i know the resons why the data mdf file shrink is false.
Madhu Sasi Nair at 7-Oct-13 3:10am
Can you run the query given below and post the size of both the mdf and ldf file -

sp_helpdb RMS
kalisiddayya at 7-Oct-13 3:17am
db_size=182032.00 MB,Database size=164930560 KB(dataonly),logfile size=21470208 KB(log only)
kalisiddayya at 7-Oct-13 3:21am
database growth=153600000 KB (dataonly) from exec sp_helpdb 'RMS'
Madhu Sasi Nair at 7-Oct-13 3:29am
it seems some bulk data import or insertion has happened on your database due to which mdf file size is large.
kalisiddayya at 7-Oct-13 4:35am
no.i haven't do any bulk data insertion.log file is around 20 GB.i have to shrink the log file.that is problem i think

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 700
1 494
2 Sergey Alexandrovich Kryukov 449
3 Afzaal Ahmad Zeeshan 444
4 CPallini 386
0 OriginalGriff 1,065
1 Sergey Alexandrovich Kryukov 683
2 DamithSL 681
3 Afzaal Ahmad Zeeshan 662
4 CPallini 555

Advertise | Privacy | Mobile
Web02 | 2.8.150731.1 | Last Updated 7 Oct 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100