Click here to Skip to main content
Rate this: bad
good
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.
 
USE RMS;
GO
EXEC sp_spaceused @updateusage = N'TRUE';
GO
 
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 20:18pm
Edited 6-Oct-13 21:46pm
v4
Comments
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 database.it is increase suddenly.can i know the resons why the data mdf file increase.auto 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 476
1 Sergey Alexandrovich Kryukov 215
2 CHill60 195
3 Afzaal Ahmad Zeeshan 145
4 TheRealSteveJudge 120
0 Sergey Alexandrovich Kryukov 9,061
1 OriginalGriff 7,920
2 Peter Leow 4,774
3 Kornfeld Eliyahu Peter 3,210
4 Maciej Los 2,176


Advertise | Privacy | Mobile
Web04 | 2.8.150327.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