Monthly Archives: August 2010

Maintenance Plan "No description found" error

for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description found” and you cannot edit the Maitainance plan. problem could be the software you install is confilicting with sql server … Continue reading

Posted in Bug, General, Installation, What I learned today | Tagged , | Leave a comment

Lock page in memory

When you configure the memory and on your system if other applications are also present, in such cases de-allocation of memory may impact huge performance issue. so lock page memory is useful here as to prevent/reserve the memory for Sql … Continue reading

Posted in Memory, Others, Performance Tuning, What I learned today | Tagged , | Leave a comment

Difference between Mirroring and Log Shipping

It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to India and changed my job  part of life ,okay  back to India (Pune). Lastly I wrote a blog on High Availability … Continue reading

Posted in Disaster Recovery, High Avaliability, Log Shipping, Transaction Log, What I learned today | Tagged , | Leave a comment