Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2001
    Posts
    6

    Unhappy Unanswered: 18278:database log truncated:database mydb

    SQL 2K sp2 on NT4 EE SP6a.
    During the DTS Import operation from the production Server
    (SQL 7.0 SP1) to the Test Server (SQL 2K SP2) I receive
    the following notification error on the NT application log:
    EVENT ID: 17055
    Source: MSSQLSERVER
    Type: Error
    category: Backup
    Description:18278:
    Database log truncated: Database: XXX

    The operation of Import succeed, but I have the "red
    error" on my NT application log.
    Can someone help me on this?
    Thank you very much.
    Franco

  2. #2
    Join Date
    Feb 2002
    Posts
    15
    have you checked www.microsoft.com/technet yet?

  3. #3
    Join Date
    Mar 2002
    Location
    Switzerland
    Posts
    2
    yes, but no answer.

  4. #4
    Join Date
    Feb 2002
    Posts
    15
    ah...it occurs to me that DTS is a pig of a thing with different SP versions on SQL.

    It just hates it. Something to do with login problems.

    Update your prod box ( or down grade your test box ) - I seem to recall seeing an article on www.sqldts.com about this.

    Post back if probs.

    J.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    This is a known bug - Please refer to the following document:

    Article

    Good luck :-)

  6. #6
    Join Date
    Mar 2002
    Location
    Switzerland
    Posts
    2
    Thank you

  7. #7
    Join Date
    Mar 2002
    Posts
    9
    See q308267

Posting Permissions

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