balasaukri (6/19/2013)
Hence please help me to free up space.
Why? SQL Server uses memory for performance reasons, disk access is slow. Why do you want to reduce its memory usage? All you'll do if you force it to release memory is degrade performance.
p.s. Never use Task Manager to check SQL Server's memory usage, it shows incorrect results under some configurations.
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