Home Forums SQL Server 2008 SQL Server 2008 - General Insert record in DATABASE SNAPSHOT seems to block server RE: Insert record in DATABASE SNAPSHOT seems to block server

  • September 14, 2012 at 11:42 am

    #1538053

    kriki-503680 (9/14/2012)

    Thank you for your reply.

    No, I am talking about database snapshots.

    And no, they are not writeable. It just happens that the Dynamics NAV-client decided to write some record to it. And because of that the session hangs and I am not able to kill it in SQL server. I would expect some error generated by SQL Server would be given back to the client but it doesn't happen.

    When a SPID gets hung, there is no error. Nothing has technically broke yet. All you can do is watch for things like this via the regular use of sp_who2 and other trace processes.

    I do recommend, however, you get the vendor of that Dynamics NAV-client to fix the silly thing before it brings down your database. Or rename the snapshots to see if maybe it's mistaking the snapshots for the real databases.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.