Professional Web Applications Themes

Transaction Log - Microsoft SQL / MS SQL Server

SQL 2K Is it possible to apply TRANSACTION LOG to a database while another process (SP) reading data from the same db.?? In my case, the job which applies 'Transaction Log' failed with an error message [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server]Database in use. The system administrator must have exclusive use of the database to run the restore operation. [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally. Once the process (SP) completed, hourly transaction log job start working .. Any thoughts/Suggestions to handle this !! Thx Sh...

  1. #1

    Default Transaction Log

    SQL 2K

    Is it possible to apply TRANSACTION LOG to a database while another process
    (SP) reading data from the same db.??
    In my case, the job which applies 'Transaction Log' failed with an error
    message

    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL
    Server Driver][SQL Server]Database in use. The system administrator must
    have exclusive use of the database to run the restore operation.
    [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation
    terminating abnormally.

    Once the process (SP) completed, hourly transaction log job start working ..

    Any thoughts/Suggestions to handle this !!

    Thx
    Sh


    Shamim Guest

  2. #2

    Default TRANSACTION LOG

    Hi...

    might be simple enough for u but tough enough for me.
    Well how to see transaction log with or without help of
    enterprise manager.
    Please, any help is regarded heartly.
    Thanks
    Manoj
    MANOJ Guest

  3. #3

    Default Re: TRANSACTION LOG

    If you are asking how to know the Log files data then:

    sp_helpdb 'DBName'

    gives you some info ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "MANOJ" <COM> wrote in message
    news:016c01c363b7$81a22cc0$gbl... 


    Vinodk Guest

  4. #4

    Default Re: TRANSACTION LOG

    If you are wanting to see what is in the active log you can use select *
    from ::fn_dblog(null,null) but it probably won't make sense to you. If you
    have a need to see what activity is in the log you might consider Lumigent
    Log Explorer http://www.lumigent.com

    HTH

    --
    Ray Higdon MCSE, MCDBA, CCNA
    ---
    "MANOJ" <COM> wrote in message
    news:016c01c363b7$81a22cc0$gbl... 


    Ray Guest

  5. #5

    Default Transaction log

    Hi..
    I have been asked many times the following question...
    "HOW TO SEE THE TRANSACTION LOG THROUGH ENTERPRIZES
    MANAGER"
    Well i think its not possible but i m not sure.
    U R any help will help me getting a forture.
    THANKS FROM THE HEART in advance
    Regards
    Manoj

    Manoj Guest

  6. #6

    Default Re: Transaction log

    You can't. You need 3:rd party tools to get understandable info from the tlog. One such is
    www.lumigent.com.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Manoj" <com> wrote in message news:08ac01c3686e$b76dbf20$gbl... 


    Tibor Guest

Similar Threads

  1. Cant Serialize transaction
    By szhark in forum Macromedia ColdFusion
    Replies: 6
    Last Post: June 27th, 10:39 AM
  2. WS-Transaction
    By moko in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 13th, 12:25 AM
  3. Transaction
    By basidati in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: August 8th, 03:41 PM
  4. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139