April 29, 2014 at 6:14 am
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...
April 29, 2014 at 7:26 am
- 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.
April 29, 2014 at 10:24 am
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. 😎
April 29, 2014 at 10:58 pm
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...
April 30, 2014 at 12:39 am
April 30, 2014 at 1:27 am
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."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply