New persopn (10/19/2013)
here i have shrink the log now we got 30 gb space. here we have 360gb log now. can i reduce it up to 300gb.
No way to answer that. We don't know your environment, we don't know how large the log needs to be. Maybe you can, maybe you can't, maybe it'll grow straight back, maybe it won't.
You need to do some investigations, see what it is that requires the most log space, how much it needs, whether or not it can be tuned.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability