none
Can't choose a different SQL Server to restore to RRS feed

  • Question

  • I'm trying to restore a small SQL Server 2000 database that is being backed up by DPM 2010 to a new (alternate) server also running SQL2000, but when I select Browse to choose the new server I only see 2 servers running SQL Server 2008, and not any of several other SQL Server instances (both SQL2000 and SQL2008) that are being protected by DPM. Is there some reason it's not showing me the other servers? Something else I need to do first?
    • Moved by Praveen D [MSFT] Monday, July 19, 2010 7:14 AM Moving to DPM SQL Protection Forum (From:Data Protection Manager)
    Tuesday, June 29, 2010 3:00 PM

Answers

  • Hi,

    Do you have SP4 installed on the concerned SQL 2000 servers? If yes, Please check the following:

    1. On the concerned server use the command “vssadmin list writers” to check if MSDEWriter is in stable condition (the MSDEWriter service is part of the VSS infrastructure). Restart the VSS service.

    2. The reason that the protection wizard in DPM UI console does not show SQL Server could be due to authentication issues. There is the KB article that talks about “Problems when the writer tries to connect to SQL Server due to authentication issues”. The link to the KB article: http://support.microsoft.com/kb/919023

    Thanks,

    Hitesh [MSFT]

     

    Monday, July 26, 2010 9:29 AM

All replies

  • how are you restoring? with the dpm console or the sql end user recovery tool? if the last is the case check your recovery role

    are the os'es ont both sql 2000 boxes the same?

    this can also help

    http://technet.microsoft.com/en-us/library/ff399066.aspx

    regards,

    Alex

    Tuesday, June 29, 2010 3:52 PM
  • I'm using the DPM console. The source OS is W2K3, the destination is W2K8, but both are 32-bit.
    Tuesday, June 29, 2010 4:18 PM
  • On a possibly related note, I can't select the SQL Server instance on the new server to add to a Protection Group either - all I see when I expand the server is "All Shares", "All Volumes" and "System Protection". No "All SQL Servers" like I see on other servers.

    The new server is running SQL Server 2000 on top of Server 2008 SP2 x86.

    Tuesday, June 29, 2010 7:30 PM
  • Is the new SQL server 2000 installed with SP4?

    Cheers,

    Mike


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Tuesday, June 29, 2010 8:01 PM
    Moderator
  • It sounds like the server in question may not have the SQL vss writer in a good state (or quite likely is not present or not running at all).  I would start on the SQL machines and do a vssadmin list writers.  Look for a SQL writer and what state it is in.  If you don't see it, look for a SQL Server VSS Writer service to see if it is running.

    One other side note, if you choose to restore from the "latest" version, you will not be able to restore to alternate SQL servers at all.


    Thanks, Chris Bu - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, July 20, 2010 3:02 PM
    Moderator
  • Hi,

    Do you have SP4 installed on the concerned SQL 2000 servers? If yes, Please check the following:

    1. On the concerned server use the command “vssadmin list writers” to check if MSDEWriter is in stable condition (the MSDEWriter service is part of the VSS infrastructure). Restart the VSS service.

    2. The reason that the protection wizard in DPM UI console does not show SQL Server could be due to authentication issues. There is the KB article that talks about “Problems when the writer tries to connect to SQL Server due to authentication issues”. The link to the KB article: http://support.microsoft.com/kb/919023

    Thanks,

    Hitesh [MSFT]

     

    Monday, July 26, 2010 9:29 AM
  • If the above suggested answer does not help in resolving the thread please re-open it.
    Thanks, Chris Bu - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, August 12, 2010 8:27 PM
    Moderator
  • I have the same problem after installing Roll-up update for DPM 2010. Before the update I was able to restore database to any SQL Server, but now I can select only SQL Servers installed on DPM servers.
    Thursday, March 24, 2011 10:36 AM