Delete SSISDB

  • We enabled / created SSISDB in one of our non-prod environments before we discovered we aren't allowed to use SSISDB on our servers (long story, don't ask). Now I'm trying to figure out if we can just delete the database or if there is something else we need to do in order to properly remove it.

    All the articles Google points me to talks about cleaning up old projects and data in SSISDB. I can't find a single one about dropping / deleting / removing SSISDB itself.

    Does anyone know if it will cause any problems if I just drop the database?

    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.

  • Brandie Tarvin wrote:

    We enabled / created SSISDB in one of our non-prod environments before we discovered we aren't allowed to use SSISDB on our servers (long story, don't ask). Now I'm trying to figure out if we can just delete the database or if there is something else we need to do in order to properly remove it.

    All the articles Google points me to talks about cleaning up old projects and data in SSISDB. I can't find a single one about dropping / deleting / removing SSISDB itself.

    Does anyone know if it will cause any problems if I just drop the database?

    I can't imagine any issues at all, though it's not something I have ever done. I'd be tempted to take it offline for a week or two first, just in case something unexpected happens and it needs to be reanimated quickly (please post if it does, as it would be interesting to know).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • You also need to remove the SSIS maintenance agent job - but other than that there shouldn't be any issues.  That system will still think it has been configured though - not sure what would happen if you tried to re-enable it again.

    It's too bad, I know you have had a lot of issues with SSIS in the past and the recommendations have all been to upgrade to use the catalog.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 3 posts - 1 through 2 (of 2 total)

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