Post reply

Views that are prefixed with _dta_mv

  • June 9, 2010 at 9:35 am

    #221999

    First post 🙂

    I was researching why one of my subscriptions was failing and it had that the table could not be dropped because it was being referenced by a view named '_dta_mv_2'. When I looked into my subscriber's database, there were a number of these views with different numbers at the end. Can you help me understand where they came from and what they do?

    Thanks

  • June 9, 2010 at 11:25 am

    #1178143

    Welcome!

    Those are very likely to be detritus from the Database Tuning Advisor. Why they are there? Hard to say, but it's likely that someone was running the DTA and had it crash, which may have caused the views to be left behind. Regardless, you should be able to drop this without issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 9, 2010 at 2:42 pm

    #1178276

    Thanks for the reply.

    I've deleted those views and replication was reinitialized just fine.

    And FYI, I just bought your book! lol 😉

  • June 9, 2010 at 2:51 pm

    #1178287

    James O. (6/9/2010)

    Thanks for the reply.

    I've deleted those views and replication was reinitialized just fine.

    And FYI, I just bought your book! lol 😉

    Glad I could help. I hope the book proves useful.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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