Post reply

truncating transaction log problem

  • January 29, 2006 at 2:03 pm

    #170741

    hy i am rashid zaib

    i have problem in backing up database

    my transaction log is full

    when i use the staement to truncate the log

    backup log databasename  with truncate_only

    dbcc shrinkfile('dbname_log')

    i recieve the message 2023 the database must be serialized what is meant by this

    can any one help me to solve this problem

    RAGHU i dont have any idea of isolation pls solve my problem all

    condition i have tell you

    thanks for your response

    thank you very much

     

  • January 30, 2006 at 3:52 am

    #617678

    Hi Rashid,

    Did you include any isloation level for your database that ur trying to take the backup?

    Cheers,

    Raghu Pyapili

     

     

  • February 3, 2006 at 1:40 pm

    #618793

    Perhaps if you post the exact backup statement(s) and error(s), it will help people get a better understanding.  You might also include the results of sp_helpdb

  • February 6, 2006 at 10:41 pm

    #619155

    Hi,

    Rashid, How many people are using the Database,If many are using it you need to recheck the Transaction Locking behaviour of your transactions

    Cheers,

    Raghu Pyapili

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

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