SQL LOG Size
Hi Experts,
several days ago I have shrinked my logfile for SQL.
Now it is again 50GB. But inside the file 1% is used.
My backup is set with BE 2012.
I have a Full Backup each week.
I have two incremental jobs for DIFFERENTIAL and LOGS.
So why the grows and just 1% is filled ?
several days ago I have shrinked my logfile for SQL.
Now it is again 50GB. But inside the file 1% is used.
My backup is set with BE 2012.
I have a Full Backup each week.
I have two incremental jobs for DIFFERENTIAL and LOGS.
So why the grows and just 1% is filled ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There is another DB on the server .
The MDF file has 20GB and the LDF file has 85GB.
The report cannot find any extensions about the logfile.
The LDF file is used with 0.5%.
But the LDF file has 50% of indexes.
Can I shrink the file with the gui and reorganize the logfile ?
The MDF file has 20GB and the LDF file has 85GB.
The report cannot find any extensions about the logfile.
The LDF file is used with 0.5%.
But the LDF file has 50% of indexes.
Can I shrink the file with the gui and reorganize the logfile ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The DB has two files.
db.mdf and db.ldf
Strange is , the db.mdf has just 20GB
The db.ldf file has 80GB
And the report of the db shows no growing activity of the db.ldf
db.mdf and db.ldf
Strange is , the db.mdf has just 20GB
The db.ldf file has 80GB
And the report of the db shows no growing activity of the db.ldf
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thanks for the infos.
ASKER
But how to find out how big are the indexes ?