Category: SQL

SQL Auto Protection Fails

Using DPM 2012 had an error with SQL Auto Protection.  In the error, it says to run “AutoProtectInstances.ps1”  When I did that, I got this error: Start-DPMAutoProtection : DPM could not enumerate SQL Server instances using Wi ndows Management Instrumentation on the protected computer <ComputerName> . (ID: 965) Please make sure that Windows Management Instrumentation… Continue reading SQL Auto Protection Fails

The stub received bad data – DPM backup of a SQL DB

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 – DPM backup of a SQL DB

SQL Queries

I don’t usually do a lot with SQL, but lately I have found myself having to look at, and work with SQL a good bit.  It seems that things come in waves.  Anyway, I was looking for a quick way to copy a table from one Database to another and came across this blog which… Continue reading SQL Queries

DPM could not connect to SQL reporting services because of IIS connectivity

I am running Data Protection Manager 2007 on Windows Server 2008 (x64).  I have not been able to use the reporting piece, and haven’t been running DPM long enough to wonder much about it, but when I went to finally figure it out the answer was rather simple.  If you want to fix it, the… Continue reading DPM could not connect to SQL reporting services because of IIS connectivity

SQL for Tivoli Storage Manager

 Found this web page that has sample queries for TSM. This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). Here you can find out a lot of selects that will help you to get information from TSM and to construct your own SQL statements. SQL for Tivoli Storage Manager

SQL and ODBC

I was trying to figure out how to get some data from an ODBC source and put it into SQL, and found a post with an interesting possible answer:  Recently, I discovered an issue with SQL Server Integration Services (SSIS) regarding how the Execute SQL Task item handles returning a result set to the control flow. Lets start by… Continue reading SQL and ODBC

Product instance … has had update 3054 installed…

So when I tried to install the update that I downloaded in my earlier post, I got the following message: The product instance SQL Tools has had update 3054 installed. You do not need to install this update. An update equal to or greater than 3159 should be downloaded. Isn’t that special…  Guess I need… Continue reading Product instance … has had update 3054 installed…