Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2003
    Posts
    12

    Unanswered: Database Lock! Urgent Please!

    Hello folks!
    I'm with two locks on a database and I can't access others databases too, except the master.

    I've tryed to kill the lock, but I didn't have sucess.

    Please help me!!!
    Cheers!
    Rafael

    SPID DBID OBJID INDID TYPE MODE STATUS
    9 5 0 0 DB S GRANT
    9 5 0 0 DB X GRANT
    51 1 85575343 0 TAB IS GRANT
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What are the spids doing?

    Are they yours?

    Are you blocking yourself?

    Did you look at sp_lock?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    12
    Yes, this spid 9 is me.
    But I'm not getting access. I've already disconected.
    Take a look on the screenshot
    Attached Thumbnails Attached Thumbnails sp_who.jpg  
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

  4. #4
    Join Date
    Feb 2004
    Posts
    492

    Re: Database Lock! Urgent Please!

    What do you mean when you say that you can't access other databases?

  5. #5
    Join Date
    Nov 2003
    Posts
    12
    I mean that I can't.

    When I try to access a database via Entreprise, Query Analyser, etc..
    like USE DB_Emplacamentos, DB_Cadastro, whatever, any database on server, my command or my screen keeps trying to connect to the database for the enternity.

    I dunno why this is happing. I saw my SQL Server Logs and some erros like this was found:

    * Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
    * Skipping startup of clean database id 6
    * Skipping startup of clean database id 7
    * Skipping startup of clean database id 8
    * Skipping startup of clean database id 9
    * Skipping startup of clean database id 10
    * Analysis of database 'DB_Emplacamentos' (5) is 3% complete (approximately 1726 more seconds)

    Man, I'm thinking to reinstall the instance of SQL Server and try to restore the database. It is really, really strange.

    Cheers!
    Rafael
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    OK. This looks like SQL 2000. If that is the case, then SPID 9 is not you. Any spid under 50 is a system process. It appears you have just rebooted this machine, and have the "long transaction blues". DB_Emplacamentos will need 20 minutes for just the analysis portion of recovery. Rolling forward, and rolling back could take a bit of time, too. This can happen when you do a lot of re-indexing, then reboot the server (only index creation statements and page allocations, and not all the page changes are recorded in the logs), or if you have an immense transaction that was halfway done when you rebooted. Out of curiosity, how but is DB_Emplacamentos?

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Oh, I imagine you are getting login errors something like "Can not open default database"?

  8. #8
    Join Date
    Nov 2003
    Posts
    12
    This database name is like DB_CarIDs.
    I have a table with aprox. 45 million rows. It's a little bit big.LOL
    The datafiles are around 20GB.

    Well, I'll leave the database trying to restabish until tomorrow. If not, I'll start the McGiver's process of reastabilish a 20GB backup.LOL

    Thank's for your help. I really appreciate that.

    Rafael
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

  9. #9
    Join Date
    Nov 2003
    Posts
    12

    Talking ROLLBACK is like a DOG, always know the way to comeback home!

    ROLLBACK is like a DOG, always know the way to comeback home!

    My databases are allset now!!!
    Yeaaah!!!

    Tks all!

    Cheers
    Rafael
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •