Removing Duplicate records RRS feed

  • Question

  • Experts,

    We have SMS Environment with 3000 clients, SQL 2000 as a Database Server and size of the DB is MDF - 40 GB, LDF - 20 GB. this is huge size. I need to clean up the duplicate data's in SMS

    a. How to identify the duplicate record in SMS?

    b. How to clean up the duplicate record in SMS?

    c. How to clean up the SMS Database?

    d. what are the maintenance task needs to be configure for maintain the SMS database?

    Thursday, December 16, 2010 4:37 AM


  • Hi,

    There is no maintenance taks that will remove duplicate records in the database. You should however always configure the Delete Inactive and Delete Obosolete clients. For Duplicate records you will need to identify them and delete them. Check this post for more information http://support.microsoft.com/kb/837374 You wil also find a query to locate duplicate records in the post.

    Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
    Thursday, December 16, 2010 6:39 AM