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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 152, Visits: 484
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


Regards
Chowdary...
Post #1565875
Posted Tuesday, April 29, 2014 7:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:00 PM
Points: 341, Visits: 751
- 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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 2,220, Visits: 6,004
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 152, Visits: 484
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....


Regards
Chowdary...
Post #1566208
Posted Wednesday, April 30, 2014 12:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 2,220, Visits: 6,004
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