Click here to Skip to main content
12,349,355 members (70,909 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.

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 19:18pm
Edited 6-Oct-13 20:46pm
v4
Comments
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 database.it is increase suddenly.can i know the resons why the data mdf file increase.auto 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
Web01 | 2.8.160621.1 | Last Updated 7 Oct 2013
Copyright © CodeProject, 1999-2016
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