SQL Database missing from DPM 2007

Having fixed my SQL 2005 issues with DPM 2007, I found my main production SQL database was missing from the list of resources available to be protected. When attempting a normal SQL backup, I got an error message telling me that the Full Text Index was missing.

I recreated the Full Text Index, (got lost when changing SQL versions - No backup, that's what DPM was supposed to do!), and everything worked great.

The thing I learned here was, if DPM is having problems protecting a resource, try another backup type for more information on the error!

DPM SQL Issues

I had the following scenario:

• DPM 2007 Running on Windows Server 2003 R2 SP2 (x86)
• SQL 2005 Standard (x86) running on Windows Server 2008 (x64)

DPM would not protect the SQL databases, and kept giving errors that the protection was "inconsistant". There were lots of SQLVDI errors in event viewer, including a BADMEM error.
To cut a long story short, I found the fix was to replace the x86 version of SQL 2005 with an x64 version.