How to find the reason behind the Disk Space Growth in my sqlserver

Posted Date: 03 Nov 2009 Posted By: G.Hemadribabu Member Level: Gold Points: 1 Responses: 4

Hi,

it is clear that in my server, it is trowing me Diskspace issue. like F Drive is having only 50 MB . alert had also been thrown, but i would like to know the reasong behind that. pls let me know how to find the reason, like why it is consuming more amount of Disk Space.

I am using sql server 2000

pls tel me the meathod to be followed to fing the disk space growth

thank you

Responses

Author: ABitSmart 03 Nov 2009

Member Level: Diamond

Rating:

Points: 2

Generally it's the log file which takes up a lot of space. How you checked the log file size ?

Author: G.Hemadribabu 03 Nov 2009

Member Level: Gold

Rating:

Points: 2

that is what is i need . But u r asking me the same question wht i ask u

Author: lakshmi Narasimhulu 03 Nov 2009

Member Level: Gold

Rating:

Points: 2

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

in this path u will find the log files

eg:Testing_log.ldf

Author: Mr. J Shah 03 Nov 2009

Member Level: Gold

Rating:

Points: 2

you can also use dbcc sqlperf('LogSpace')

You can use below command to reclaim the space.
DBCC ShrinkFile
DBCC ShrinkDatabase

Regards,
JShah
http://sqldbpool.wordpress.com/

Post Reply

You must Sign In to post a response.

	Next : Couldn't install sql server 2005 database engine in vista premium
	Previous : Views
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use