Click here to Skip to main content
12,881,797 members (29,289 online)
Rate this:
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
Updated 6-Oct-13 20:46pm
Madhu Sasi Nair 7-Oct-13 1:34am
This increase in size has been suddenly or over a period of time?
kalisiddayya 7-Oct-13 1:53am
suddenly it is increase
kalisiddayya 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 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 7-Oct-13 3:17am
db_size=182032.00 MB,Database size=164930560 KB(dataonly),logfile size=21470208 KB(log only)
kalisiddayya 7-Oct-13 3:21am
database growth=153600000 KB (dataonly) from exec sp_helpdb 'RMS'
Madhu Sasi Nair 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170422.1 | Last Updated 7 Oct 2013
Copyright © CodeProject, 1999-2017
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