none
System Center 2012 DPM Service Pack 1 cannot find SQL 2008 R2 instances RRS feed

  • Question

  • Hi there,

    I am experiencing some difficulties while trying to backup SQL 2008 R2 databases. When I browse the SQL server in "New Protection Group" screen, I can see "All Volumes", "All Shares" and "System Protection" but no SQL instances. 

    There is a slight catch which is whenever I remove the databases attached to SQL server, I can see the default databases "Master", "model" and so on. 

    Reconnecting the databases will result in disappearance of the instances that were shown in DPM.

    I can see the SQL instances on DPM, but all other SQL servers fail to be shown on the "New Protection Group" screen.

    any help would be appreciated. 

    Tuesday, March 26, 2013 9:59 AM

Answers

  • Nice,

    So now, could you verify on your SQL server that :

    • NT AUTHORITY\SYSTEM account has sysadmin role in your SQL instance
    • There is no trailing space in the name of one of your DB with this SQL query :
      select '#' + name + '#' from sys.databases

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    • Marked as answer by ronitombak Wednesday, March 27, 2013 8:53 AM
    Tuesday, March 26, 2013 2:49 PM

All replies

  • Hi,

    On your SQL server you should verify that service SQL Server VSS Writer is started.

    You also may restart it.

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    Tuesday, March 26, 2013 11:05 AM
  • Hi,   thanks for the reply.

    SQL Server VSS Writer service on the SQL server I want to backup is already running, I restarted the service. The service uses "Local System" logon account. 

    vssadmin list writers command on the SQL server returns these below. All seems normal. Still no luck! Any more advice?


    Writer name: 'Task Scheduler Writer'
       Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}
       Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}
       State: [1] Stable
       Last error: No error

    Writer name: 'VSS Metadata Store Writer'
       Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}
       Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}
       State: [1] Stable
       Last error: No error

    Writer name: 'Performance Counters Writer'
       Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}
       Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}
       State: [1] Stable
       Last error: No error

    Writer name: 'System Writer'
       Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
       Writer Instance Id: {19baed0d-f0a8-46d5-823c-3b9424b2e95f}
       State: [1] Stable
       Last error: No error

    Writer name: 'ASR Writer'
       Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
       Writer Instance Id: {bb40fb48-02fa-477f-852a-bb176fe75d04}
       State: [1] Stable
       Last error: No error

    Writer name: 'Registry Writer'
       Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
       Writer Instance Id: {7d455abf-839e-49d1-b25f-033e7bca6b9f}
       State: [1] Stable
       Last error: No error

    Writer name: 'Shadow Copy Optimization Writer'
       Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
       Writer Instance Id: {87c76289-8c0b-42ea-9c90-49f6ce5cdee9}
       State: [1] Stable
       Last error: No error

    Writer name: 'WMI Writer'
       Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
       Writer Instance Id: {7b088fd7-92dd-4a15-a778-26ceba95f0e0}
       State: [1] Stable
       Last error: No error

    Writer name: 'COM+ REGDB Writer'
       Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
       Writer Instance Id: {e9c7e563-4148-48a7-a174-29a385ce1c3a}
       State: [1] Stable
       Last error: No error

    Writer name: 'BITS Writer'
       Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0}
       Writer Instance Id: {f0841733-f0d7-423b-b0d4-5a42b636066b}
       State: [1] Stable
       Last error: No error


    Tuesday, March 26, 2013 11:49 AM
  • Hi,

    I cannot see your SQL writer ? (Maybe crop by copy/paste?)

    On your SQL server could you run this command in a command prompt :

    Diskshadow [enter]

    List writers [Enter]

    Search for string Writer "SqlServerWriter" and verify that the writer is able to enumerate content of your SQL instance.

    let's us know the result.

    Stephane.


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    Tuesday, March 26, 2013 1:07 PM
  • I tried looking for the string  Writer "SqlServerWriter" but there is none. 

    just to be clear, I should look for this on the SQL server that I want to back up, not on the DPM server    right?

    Tuesday, March 26, 2013 1:55 PM
  • Yes you're right.

    Could you run this powershell command on your SQL server and copy/past result:

    Get-Service | ? { $_.name -like 'mss*' -or $_.name -like 'sql*' } | ft -auto

    Stephane



    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog


    Tuesday, March 26, 2013 2:12 PM
  • here it is


    Status  Name                                          DisplayName
    ------  ----                                                 -----------
    Running MSSQLSERVER                           SQL Server (MSSQLSERVER)
    Stopped MSSQLServerADHelper100        SQL Active Directory Helper Service
    Running MSSQLServerOLAPService         SQL Server Analysis Services (MSSQLSERVER)
    Stopped SQLBrowser                              SQL Server Browser
    Running SQLSERVERAGENT                     SQL Server Agent (MSSQLSERVER)
    Running SQLWriter                                 SQL Server VSS Writer

    Tuesday, March 26, 2013 2:41 PM
  • Nice,

    So now, could you verify on your SQL server that :

    • NT AUTHORITY\SYSTEM account has sysadmin role in your SQL instance
    • There is no trailing space in the name of one of your DB with this SQL query :
      select '#' + name + '#' from sys.databases

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    • Marked as answer by ronitombak Wednesday, March 27, 2013 8:53 AM
    Tuesday, March 26, 2013 2:49 PM
  • You are absolutely right.  One of our databases had a trailing space which was not easy to notice. Using the SQL query select '#' + name + '#' from sys.databases  helped me find the database and after detaching it from the SQL server, DPM worked just fine.

    thanks for the quick response and bulls-eye on the problem.

    Wednesday, March 27, 2013 8:55 AM