On Fri, 08 Aug 2008 05:16:55 GMT, Manoj saini<tomksaini@gmail.com>
wrote:
Quote:
|
>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.
|
Then it is a good thing you are using Microsoft SQL Server, since
running BACKUP does not lock the database.
Quote:
|
>But to hit the DB every min is not good solution.
|
It would certainly be crude, and painful for the user, but it would
not matter to the database.
Roy Harvey
Beacon Falls, CT
