Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Am using Windows Server 2008R2,In this C:/ Drive Space getting increase Expand / Collapse
Author
Message
Posted Tuesday, April 29, 2014 6:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 90, Visits: 241
Dear All,

I know this is some what get irritate to you,Very sorry for that but i hope that you can give me some suggestions for This.

Am using Windows Server 2008R2,
In this Server C:/ drive space is getting increase day by day
as per my knowledge i have to format that system.
If is there any other chances to get space and remove unwanted things from my Server
Post #1565875
Posted Tuesday, April 29, 2014 7:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 280, Visits: 615
- You don't have to reformat your system (by which I assume you mean your C: drive)
- If you have a database that is growing, its space usage will grow. That is normal.
- Check the logging setup for the database and verify that it is set to what you need
- Roll the logs on a regular (e.g. daily, weekly, monthly) basis and set up a policy to remove
old logs.
- Move the logs to a different drive (preferably a different spindle)
- Make sure your INSERTS are in step with your CLUSTERED INDEX. They can work against each other if not set up correctly and cause fragmentation and poor fill ratios.
Post #1565911
Posted Tuesday, April 29, 2014 10:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 1,309, Visits: 3,753
Chowdary's (4/29/2014)
Dear All,

I know this is some what get irritate to you,Very sorry for that but i hope that you can give me some suggestions for This.

Am using Windows Server 2008R2,
In this Server C:/ drive space is getting increase day by day
as per my knowledge i have to format that system.
If is there any other chances to get space and remove unwanted things from my Server

Quick questions, is there a SQL Server installed on the system? If so, where is the default data directory? Is tempdb on C: ? Is any db on C: ?

Must say that I fail to understand how formatting anything solves the problem.
Post #1566047
Posted Tuesday, April 29, 2014 10:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 90, Visits: 241
Thank you all,
In my system SQL server was installed,
My DB Log size is 32GB now ,DB is in Full Recovery model.
Day to Day Log size is getting increasing.
If I take a Log backup then the size of Log will reduce or not?

Regards....
Post #1566208
Posted Wednesday, April 30, 2014 12:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 1,309, Visits: 3,753
Check out
Stairway to Transaction Log Management in SQL Server
Post #1566226
Posted Wednesday, April 30, 2014 1:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Looks like your system is not production. If it's not prod you can change the recover to simple and shrink the logfile. If you would like to keep the full recovery you must have t-log backup.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1566247
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse