Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    16

    Lightbulb Unanswered: why i get this error message from database

    hi all,i want to know why i get this error message, following
    message 4207 level 16 state 1
    "dump trans is not allowed because a non_logged operation was performed on the db.dump your db or use dump trans with truncate_only until you can dump your db"
    what's operation can get this result?
    thanks alot

  2. #2
    Join Date
    Mar 2003
    Posts
    23
    Did you happen to do a BCP operation on the DB

  3. #3
    Join Date
    Apr 2004
    Posts
    16

    Post no ,but

    thank you for your reply,but we didnot do bcp operation in our db,i had dump database completely twice,and then i dumped the trans ,i got the same error message msg4207,level16 state1"dump trans is not allowed ,because a non_logged operation is performed in your db dump your db or use dump trans with truncate_only until dump your db..."
    i dont know why i get these ,what other operation recieve this error message.
    thanks!

  4. #4
    Join Date
    Aug 2003
    Location
    kolkata,india
    Posts
    3
    if u have used insert into like :
    select field1
    into tab2
    from tab1

    then this type of operation are not recorded into log and called non-logged operation. In this case u cannot take back up of tran and can be possible only after dump database is done.

  5. #5
    Join Date
    Aug 2003
    Location
    kolkata,india
    Posts
    3
    if u have used select into like :
    select field1
    into tab2
    from tab1

    then this type of operation are not recorded into log and called non-logged operation. In this case u cannot take back up of tran and can be possible only after dump database is done.

  6. #6
    Join Date
    Aug 2003
    Location
    kolkata,india
    Posts
    3
    if u have used select into like :
    select field1
    into tab2
    from tab1

    then this type of operation are not recorded into log and called non-logged operation. In this case u cannot take back up of tran and can be possible only after dump database is done.

    The reason is the new table tab2 will not be included in backup if u dump tran. So u will loose some tables, hence dump tran is not allowed after non-logged operation.

  7. #7
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    Another non-logged operation would be a truncate table..

Posting Permissions

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