{"id":137,"date":"2009-03-26T08:27:54","date_gmt":"2009-03-26T13:27:54","guid":{"rendered":"http:\/\/nukeitmike.com\/blog\/2009\/03\/26\/the-stub-received-bad-data-dpm-backup-of-a-sql-db\/%20"},"modified":"2009-03-26T08:27:54","modified_gmt":"2009-03-26T13:27:54","slug":"the-stub-received-bad-data-dpm-backup-of-a-sql-db","status":"publish","type":"post","link":"https:\/\/blog.nukeitmike.com\/index.php\/2009\/03\/26\/the-stub-received-bad-data-dpm-backup-of-a-sql-db\/","title":{"rendered":"The stub received bad data \u2013 DPM backup of a SQL DB"},"content":{"rendered":"

My DPM Server:
Server 2008 x64
DPM 2007 SP1
SQL 2005 SP3 (local to DPM) <\/p>\n

Protecting:
Server 2003 SP2 x64
SQL 2005 SP3 <\/p>\n

I have about 30 databases being backed up from the one client machine.  All of them backup just fine except one.  Every time I try to do a synchronization or a full backup I get the following error: <\/p>\n

\n

Triggering synchronization on *myserver\\mydatabase* failed: Error 46: DPM failed to perform the operation because too many objects have been selected. Select fewer objects and then retry this operation. <\/p>\n

Error details: The stub received bad data (0x800706F7) <\/p>\n

Recommended action: Select fewer objects. 1) If you are trying to protect a large number of data sources on a volume, consider protecting the whole volume instead of individual data sources. 2)If you are trying to recover a large number of folders or files from a volume, consider recovering the parent folder, or divide the recovery into multiple operations. <\/p>\n<\/blockquote>\n

This happens even if I just select the one database.  All the other databases backup correctly.<\/p>\n

After posting in the news group<\/a>, I got a question from a Microsoft person whether full text indexing was enabled, and if so how many catalogs.  Upon investigation, it appears that this is one of the only databases that i have that has full text indexing enabled.  It has 32 indexes.  <\/p>\n

So with the suggestion of a colleague, I did a rebuild of the indexes:<\/p>\n

    \n
      \n
    1. In SQL Server Management Studio (SSMS) expand the database\/Storage\/Full Text Catalogs<\/li>\n
    2. Right click on the Full Text Catalogs folder and select Rebuild All<\/li>\n<\/ol>\n<\/ol>\n

      Then I went back to my DPM server, to the protection group and selected the database in question.  I did a \u201cCreate recovery point \u2013 Disk\u201d, \u201cCreate a recovery point by using express full backup\u201d.<\/p>\n

      That worked, so maybe that means the problem is fixed\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"

      My DPM Server: Server 2008 x64 DPM 2007 SP1 SQL 2005 SP3 (local to DPM) Protecting: Server 2003 SP2 x64 SQL 2005 SP3 I have about 30 databases being backed up from the one client machine.  All of them backup just fine except one.  Every time I try to do a synchronization or a full… Continue reading The stub received bad data \u2013 DPM backup of a SQL DB<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,17,32],"tags":[53,80,120,166],"class_list":["post-137","post","type-post","status-publish","format-standard","hentry","category-data-protection-manager","category-microsoft","category-sql","tag-backups","tag-dpm","tag-microsoft","tag-sql","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-2d","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}