Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are running a shared SQL server with a maintenance plan that is scheduled to run every night. The maintenance plan does reindexing on all db's but the maintenance plan now throws an error because of File level locking permissons. The databases mostly are Sitecore databases and are running in a website scenario. What are the pro's and cons for enabling file level locking and how can we do this quick for all databases?

share|improve this question
? SQL server automatically locks all files for databases all the time. What "file level locking" is your problem? What is your mainteannce plan doing? The databases should be accesible by SQL Server, which is the only system alowed to change them anyway. –  TomTom Feb 17 '12 at 10:44
What is a "shared" SQL server? –  joeqwerty Feb 17 '12 at 11:01
I will provide more detailed info about the maintenance plan and the errors we are running in to. –  Younes Feb 17 '12 at 11:24
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.