Re: SQL Server 2008 caching

I need to give one functionality in my application as applicationl lock.
If my databsae is get lock at the time of backup, i need to give a
message to user that daatbse has been locked and ask him to log out.
This application is in Dot net2005. Before db lock , i set one parameter
in table and read this table every min with timer. if parameter is set
then i give message to user.
But to hit the DB every min is not good solution.
Pls help he, how i can avoid hit on dataabse