Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008
    Posts
    3

    Unanswered: clear log shipping history

    I practiced log shipping in my home PC. It works fine. But there are 3 error dialog box populated for every 15 minutes. I enclosed screen shot.

    1. DW20.Exe Application Error
    2. Visual Studio just-in-Time Debugger
    3. Sqllogship.exe Application Error

    I got this error every 15 minutes. I delete everything such as maintenance plan jobs, replication, log shipping, mirroring in my SSMS. I can't find out the solution for this error. I didn't know, how to resolve this problem.

    Please advice.
    Thanks
    Jayasri
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    DW20.EXE is "Dr. Watson" for office apps. Have you looked at SQL errorlog? We need a little more than just those screenshots. SQL errorlog, app and sys event logs. Without it we're in the dark
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    May 2008
    Posts
    3

    clear log shipping history

    I enclosed details of sql error log and event log that you have mentioned in your reply. Still I could not find out. Could you please advise me?

    Thanks
    Jayasri
    Attached Files Attached Files

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Is the name of the database you're trying to log-ship testdistribut?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2008
    Posts
    3

    clear log ship

    Yes. You are correct. Now I tried to delete everything regarding log ship. Some of the them, I cannot delete it. Still I have a problem with those error.

    Thanks
    Jayasri

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Are you trying to remove log shipping and clean-up after it? If this is the case, then check your scheduled tasks (Jobs folder under SQLAgent), and either delete the job, disable the job, delete the schedule, or disable the schedule for all associated jobs.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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