Re: SQL Server 2008 caching

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Roy Harvey (SQL Server MVP)

    Re: SQL Server 2008 caching

    On Fri, 08 Aug 2008 05:16:55 GMT, Manoj saini<tomksaini @gmail.com>
    wrote:
    >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.
    >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
Working...