suddenly sql server database mdf file size increase from 10 GB to 157 GB

Question

0.00/5 (No votes)

See more:

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

kalisiddayya

Updated 6-Oct-13 20:46pm

v4

Add a Solution

Comments

Madhu 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 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 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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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