Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-08-25 : 20:22:28
|
| On 2008 SQl Servers - if the database Log File has grown more than MDF file then is it needed to be shrink?Currently LDF has growth 10 times the MDF.Or is it good to make it Automated Shrink from its Properties page?Thanks in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-08-25 : 22:00:23
|
| Its 2008 R2 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) MDF - 552 MB Corresponding LDF 5 GB (5,125,289)The db is in SIMPLE recovery mode.There is only 1 Clustered index on the PK.Please advise whether should I really shrink or not.On the contrary I was known the resultant after the shrink the possibility of Fragmentation can surmount to maximum.Just let me know what would be the exact steps for keeping Shrink and Fragmentation within the control.Many Thanks |
 |
|
|
|
|
|
Shrink