Home Forums SQL Server 2008 SQL Server 2008 Administration Object already exists, but can't drop it! RE: Object already exists, but can't drop it!

  • 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.