Post reply

Object already exists, but can't drop it!

  • April 28, 2014 at 3:12 am

    #1709083

    Hi All,

    Sorry for the extremely late response.

    Your suggestion ended up leading me to the solution. I had actually already tried it against the DB and wasn't going to bother trying again, however, eventually did and and errors where reported. I'm not sure if I made a mistake the first time or something changed however, this command with the repair switch and then the repair allow data loss worked perfectly.

    thanks HEAPS for your suggestion, much appreciated.

  • April 28, 2014 at 4:39 am

    #1709105

    ty 54262 (4/28/2014)

    this command with the repair switch and then the repair allow data loss worked perfectly.

    Ouch. You should be leery of ever using the "allow data loss" switch with that command. It literally means that data will be lost if the command needs to cut it out of the system.

    I recommend you restore from a backup of the database. In fact, google "Gail Shaw allow data loss" to see all the reasons why you should not have used that option.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 16 through 16 (of 16 total)

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