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
