Post reply

INSERT & UPDATE not working all of sudden

  • October 26, 2006 at 10:06 am

    #170850

    Hi There,

    I have a weired problem going on one of my SQL Server 2000 database where other databases are working fine on the same server.

    We have a "Products" database on our server but its stop working all of sudden & not inserting or updating few tables (ex: 'Table A', 'Table K') unless we stop & re-start the sql services again. Is there anything particular we should do on these specific tables or there is total wrong with entire "Product" database?

    Please help me in this regard how we could solve this issue.

    Thanks in advance

    Muktesh

  • October 26, 2006 at 10:17 am

    #668270

    Hi,

    Have a look on the transaction log file and check that it has the enough space. I think its due to the transaction log file.

    Take the backup of transaction long and make it empty.

    Hope this will sort out your problem.

    cheers

  • October 26, 2006 at 10:43 am

    #668282

    Hi Rao,

    Thanks for your quick reply. The current transaction log size seems just 6 MB where I have given restrict file size limit as 100 MB. Is there anything more we should concern?

    Thanks again

    Muktesh

  • October 26, 2006 at 11:52 am

    #668310

    Are you getting an error?

    I don't see enough information to help U.

  • October 26, 2006 at 11:04 pm

    #668406

    Hi Ray,

    Nope, I'm not getting any error message on server console. But its all of sudden stop doing insert & updates into few of my tables. I appreciate you help.

    Regards

  • October 27, 2006 at 4:01 am

    #668431

    Start the profiler, see and playback the statements that should be doing the work.  Also show the execution plan while playing back the statements in QA.  Maybe there are some "hidden" triggers that are screwing up with you .

  • October 27, 2006 at 10:33 am

    #668556

    I dont think there are any triggers setup on this database or tables. Should we truncate the log file and create another one?

  • October 27, 2006 at 11:04 am

    #668566

    Have u looked at the indexes to find out if thats causing the issue.

  • January 3, 2007 at 7:29 pm

    #681121

    I suggest you look at the code. I'd offer to bet you have two resources locking each other or you have a lock on a table not being released.

  • February 14, 2007 at 8:29 am

    #689720

    Would it be to just check sp_who2 when you have the issue to check for blocking...ect.

    If it were the code, could a begin tran with no commit be a cause also? Causing an open transaction?

    Can you manually insert a row when you start having the issue? Does it give you an error message when attempting to insert? For example via Query Analyzer?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply