none
DPM2010 is protecting a SQL2000 and a SQL2005 instance on the same server but it can't see a newly created SQL2000 instance RRS feed

  • Question

  • SqlServerWriter and MSDEWriter are listed in good state under VSSADMIN.

    When I tried to protect the new SQL 2000 instance, it is not listed on the SQL Data source of the server, only one SQL2000 and one SQL2005 instance are shown.

    Any ideas how to make DPM aware of the new instance?

    Wednesday, June 1, 2011 5:13 PM

Answers

  • Thank you.

    So it looks like this is a limitaion on VSS. We have seem this when a database in the default instance has the same name of named instance.

    In your case, there is a database in the default instance named AMS:

         - Component "MSDEWriter:\DEVDB01T\AMS"
            - Name: 'AMS'
            - Logical Path: 'DEVDB01T'
            - Full Path: '\DEVDB01T\AMS'

    The named instance on this system is also named AMS. This causes confusion during data source enumeration and the end result is the behavior you are seeing.

    In agent inquiry we are setting the "DataSource" field to "false" for databases of the named instance. This is because the prefix of the defaultinstance\databasename is already present and hence we are thinking that this is not a valid datasource.

    Workaround - Add at least 1 character to the database name on the default instance and inquiry will work fine.


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, June 7, 2011 10:41 PM
    Moderator

All replies

  • Hi AdminQuest,

    Which SQL service pack you have installed on this newly created instance?

    You can get the Service Pack level by logging into the new instance via SQL Server Enterprise Manager and run the query below

    select @@version

    The minimum requirement is SQL 2000 SP4 (2000.8.00.2039)

     

     


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, June 2, 2011 5:51 AM
    Moderator
  • I run this query on the new instance and the result is:

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)

    This is the same version as the Default intance which is visible on DPM.

    Thursday, June 2, 2011 2:46 PM
  • Thanks, this instance is running SQL 2000 SP4 + MS09-004 update.

    In which OS is SQL installed?


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, June 2, 2011 3:02 PM
    Moderator
  • The server is a VM running Windows Server 2003 Standard Edition with Service Pack 2

    SQL Server Enterprise Manager shows Operation System: Microsoft Windows NT - 5.2 (3790)

     

    Thursday, June 2, 2011 3:47 PM
  • Download vshadow.exe and run it from CMD.EXE on your SQL Server

    https://skydrive.live.com/redir.aspx?cid=76fc630a18325e54&resid=76FC630A18325E54!1089

    The syntax is:

    vshadow.exe -wm2

    I am interested on MSDEWriter output


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, June 2, 2011 4:16 PM
    Moderator
  • When I execute the command vshadow.exe -wm2 from the command prompt I get the following dialoge box:

    vshadow.exe - Entry Point Not Found

    The procedure entry point ShouldBlockRevertInternal coul not be located in the dynamic link library VSSAPI.DLL.

     

    Thursday, June 2, 2011 5:44 PM
  • Download the Volume Shadow Copy Service DSK 7.2 and install it on your server. Run vshadow.exe from this installation

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0B4F56E4-0CCC-4626-826A-ED2C4C95C871&displaylang=en

     


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, June 2, 2011 6:24 PM
    Moderator
  • * WRITER "MSDEWriter"
        - WriterId   = {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
        - InstanceId = {73a80977-8fb1-4cca-898b-abfc3ca51a56}
        - Supports restore events = TRUE
        - Writer restore conditions = VSS_WRE_ALWAYS
        - Restore method = VSS_RME_RESTORE_IF_CAN_REPLACE
        - Requires reboot after restore = FALSE

        - Excluded files:
        - Component "MSDEWriter:\DEVDB01T\AMS\AMS"
           - Name: 'AMS'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\AMS'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMSMaster_Data, Filespec = AMS_Data.MDF
           - Database Log: Path = E:\AMSMaster_Log, Filespec = AMS_Log.LDF
           - Affected paths by this component:
             - E:\AMSMaster_Data
             - E:\AMSMaster_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\AMSReport"
           - Name: 'AMSReport'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\AMSReport'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMSMaster_Data, Filespec = AMSReport_Data.MDF
           - Database Log: Path = E:\AMSMaster_Log, Filespec = AMSReport_Log.LDF
           - Affected paths by this component:
             - E:\AMSMaster_Data
             - E:\AMSMaster_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\master"
           - Name: 'master'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\master'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = master.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = mastlog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\model"
           - Name: 'model'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\model'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = model.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = modellog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\msdb"
           - Name: 'msdb'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\msdb'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = msdbdata.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = msdblog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\Northwind"
           - Name: 'Northwind'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\Northwind'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = northwnd.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = northwnd.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\pubs"
           - Name: 'pubs'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\pubs'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = pubs.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data, Filespec = pubs_log.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL$AMS\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS\Teamplate"
           - Name: 'Teamplate'
           - Logical Path: 'DEVDB01T\AMS'
           - Full Path: '\DEVDB01T\AMS\Teamplate'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'FALSE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMSMaster_Data, Filespec = Teamplate_Data.mdf
           - Database Log: Path = E:\AMSMaster_Log, Filespec = Teamplate_log.LDF
           - Affected paths by this component:
             - E:\AMSMaster_Data
             - E:\AMSMaster_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMS"
           - Name: 'AMS'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\AMS'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMS_Data, Filespec = AMS_Data.MDF
           - Database Log: Path = E:\AMS_Log, Filespec = AMS_Log.LDF
           - Affected paths by this component:
             - E:\AMS_Data
             - E:\AMS_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\AMSReport"
           - Name: 'AMSReport'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\AMSReport'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMS_Data, Filespec = AMSReport_Data.MDF
           - Database Log: Path = E:\AMS_Log, Filespec = AMSReport_Log.LDF
           - Affected paths by this component:
             - E:\AMS_Data
             - E:\AMS_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\fogbugz"
           - Name: 'fogbugz'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\fogbugz'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = fogbugz_20070615151233_Data.MDF
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = fogbugz_20070615151233_Log.LDF
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\master"
           - Name: 'master'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\master'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = master.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = mastlog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\model"
           - Name: 'model'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\model'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = model.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = modellog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\msdb"
           - Name: 'msdb'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\msdb'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = msdbdata.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = msdblog.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\Northwind"
           - Name: 'Northwind'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\Northwind'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = northwnd.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = northwnd.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\pubs"
           - Name: 'pubs'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\pubs'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = pubs.mdf
           - Database Log: Path = C:\Program Files\Microsoft SQL Server\MSSQL\data, Filespec = pubs_log.ldf
           - Affected paths by this component:
             - C:\Program Files\Microsoft SQL Server\MSSQL\data
           - Affected volumes by this component:
             - \\?\Volume{8c4b88d1-3923-11da-aee5-806e6f6e6963}\ [C:\]
           - Component Dependencies:
        - Component "MSDEWriter:\DEVDB01T\Teamplate"
           - Name: 'Teamplate'
           - Logical Path: 'DEVDB01T'
           - Full Path: '\DEVDB01T\Teamplate'
           - Caption: ''
           - Type: VSS_CT_DATABASE [1]
           - Is Selectable: 'TRUE'
           - Is top level: 'TRUE'
           - Notify on backup complete: 'FALSE'
           - Components:
           - Database: Path = E:\AMS_Data, Filespec = Teamplate_Data.mdf
           - Database Log: Path = E:\AMS_Log, Filespec = Teamplate_log.LDF
           - Affected paths by this component:
             - E:\AMS_Data
             - E:\AMS_Log
           - Affected volumes by this component:
             - \\?\Volume{c76bd318-bab0-11da-8a49-505054503030}\ [E:\]
           - Component Dependencies:

    This is the MSDEWriter output, only the DEVDB01T instance shows in DPM, the DEVDB01T\AMS instance does not show in DPM.

    Tuesday, June 7, 2011 9:09 PM
  • Thank you for the output.

    These databases belong to which instance? Default or AMS?

            - Database: Path = E:\AMS_Data, Filespec = AMS_Data.MDF
            - Database: Path = E:\AMS_Data, Filespec = AMSReport_Data.MDF
            - Database: Path = E:\AMS_Data, Filespec = Teamplate_Data.mdf
            - Database: Path = E:\AMSMaster_Data, Filespec = AMS_Data.MDF
            - Database: Path = E:\AMSMaster_Data, Filespec = AMSReport_Data.MDF
            - Database: Path = E:\AMSMaster_Data, Filespec = Teamplate_Data.mdf


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, June 7, 2011 9:47 PM
    Moderator
  • The first three belong to Default instance, the last three belong to AMS instance.
    Tuesday, June 7, 2011 10:01 PM
  • Thank you.

    So it looks like this is a limitaion on VSS. We have seem this when a database in the default instance has the same name of named instance.

    In your case, there is a database in the default instance named AMS:

         - Component "MSDEWriter:\DEVDB01T\AMS"
            - Name: 'AMS'
            - Logical Path: 'DEVDB01T'
            - Full Path: '\DEVDB01T\AMS'

    The named instance on this system is also named AMS. This causes confusion during data source enumeration and the end result is the behavior you are seeing.

    In agent inquiry we are setting the "DataSource" field to "false" for databases of the named instance. This is because the prefix of the defaultinstance\databasename is already present and hence we are thinking that this is not a valid datasource.

    Workaround - Add at least 1 character to the database name on the default instance and inquiry will work fine.


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, June 7, 2011 10:41 PM
    Moderator
  • This is a conflict between the name of the AMS database in the default instance and the name of the AMS instance, and to solve it we need to rename the AMS database (which is not possible) or rename the AMS instance (don't know if this is possible). Is there any other option to make DPM aware of the AMS instance to backup its databases?

    Wednesday, June 8, 2011 6:54 PM
  • Unfortunately no.

    Renaming the database or the SQL instance are the only options available for you to be able to protect these two instances through DPM.


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Wednesday, June 8, 2011 8:00 PM
    Moderator
  • I spoke with the DBA and we have detached the AMS database from the default instance and now DPM can see the AMS named instance.  I configured the protection of the databases in the AMS named instance and after it finish to create the database replicas we've attached the AMS database to the default instance.

    Now if we try to modify the Protection Group the AMS named instance does not display but we still can create recovery points of the databases in the AMS named instance. 

    This temporary solution will work for now until we can schedule the rename of the AMS named instance (I think will require a new instance installation and move the databases)

    Wilson thank you for your help.



    • Edited by AdminQuest Thursday, June 9, 2011 6:30 PM
    Thursday, June 9, 2011 2:26 PM