none
how to protect SQL 2012 on Windows 2012 R2,but the log and data are not in the same location

    Question

  • Back up sql server with dpm2012 R2, but the log and data are not in the same location,please help me to fix it,thanks.

    error:

    3B0 1194 09/10 06:19:04.136 31 dllmain.cpp(37) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL SQLWriterHelperPlugin: DLL_PROCESS_ATTACH
    13B0 1194 09/10 06:19:04.136 31 sqlmirroringpluginhelper.cpp(116) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL unique logical path : VM-DBCENTER
    13B0 1194 09/10 06:19:04.136 31 sqlmirroringpluginhelper.cpp(193) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL vss logical path : VM-DBCENTER
    13B0 1194 09/10 06:19:04.183 31 sqlmirroringpluginhelper.cpp(375) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Executing SQLQuery SELECT mirroring_role                                 FROM sys.database_mirroring                                 WHERE database_id =                                 (SELECT database_id FROM sys.databases WHERE name=N'netdb')
    13B0 1194 09/10 06:19:04.183 31 vssbaserequestor.cpp(51) [0000000000E76970] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CVssBaseRequestor: constructor [0000000000E76970]
    13B0 1194 09/10 06:19:04.183 31 vsssnapshotrequestor.cpp(104) [0000000000E76970] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CVssSnapshotRequestor::CVssSnapshotRequestor [0000000000E76970]
    13B0 1194 09/10 06:19:04.183 31 sqlmirroringpluginhelper.cpp(116) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL unique logical path : VM-DBCENTER
    13B0 1194 09/10 06:19:04.183 31 sqlmirroringpluginhelper.cpp(193) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL vss logical path : VM-DBCENTER
    13B0 1194 09/10 06:19:04.183 31 sqlwriterhelperplugin.cpp(3844) [0000000000ED4BB0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Executing SQLQuery to get Volume Names - SELECT type, physical_name                                 FROM sys.master_files                                      WHERE database_id = (SELECT database_id FROM sys.databases WHERE name=N'netdb')
    13B0 1194 09/10 06:19:04.183 31 sqlwriterhelperplugin.cpp(3856) [0000000000ED4BB0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Going to Add Volume For File - D:\netdb\Data\netdb.mdf
    13B0 1194 09/10 06:19:04.183 31 sqlwriterhelperplugin.cpp(3990) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL ssLocalVolumeGuid = [\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\], ssClusterVolGuid=[\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\]
    13B0 1194 09/10 06:19:04.183 31 sqlwriterhelperplugin.cpp(3856) [0000000000ED4BB0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Going to Add Volume For File - D:\netdb\Log\netdb_log.ldf
    13B0 1194 09/10 06:19:04.183 31 sqlwriterhelperplugin.cpp(3990) 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL ssLocalVolumeGuid = [\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\], ssClusterVolGuid=[\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\]
    13B0 1194 09/10 06:19:04.199 31 sqlwriterhelperplugin.cpp(4119) [0000000000ED4BB0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Executing SQLQuery SELECT type, physical_name                                 FROM sys.master_files                                 WHERE database_id =                                 (SELECT database_id FROM sys.databases WHERE name=N'netdb')
    13B0 1194 09/10 06:19:04.199 31 sqlwriterhelperplugin.cpp(3783) [0000000000ED4BB0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL SQL scratch space for instance - VM-DBCENTER, db - 'netdb' is 'D:\netdb\Log\DPM_SQL_PROTECT\VM-DBCENTER\netdb_log.ldf'
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(32) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournalHelper::ActivateJournal Volume Path = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\, max size = 0x0000000012C00000, alloc delta = 0x0000000001E00000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(526) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournal::GetVolumeHandle Volume Path = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(544) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournal::GetVolumeHandle Volume Path = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}, Volume Handle = 820
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(123) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL UsnJournalID    = 0x01D3D7BEB07743FE
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(124) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL FirstUsn        = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(125) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL NextUsn         = 0x00000000002C0918
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(126) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL LowestValidUsn  = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(127) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL MaxUsn          = 0x7FFFFFFFFFFFFFFF
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(128) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL MaximumSize     = 0x0000000012C00000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(129) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL AllocationDelta = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(159) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Need to reset USN true
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(526) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournal::GetVolumeHandle Volume Path = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(544) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournal::GetVolumeHandle Volume Path = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}, Volume Handle = 820
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(466) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL CUsnJournalHelper::GetNextUsnInternal(vol:820)
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(488) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL UsnJournalID    = 0x01D3D7BEB07743FE
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(489) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL FirstUsn        = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(490) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL NextUsn         = 0x00000000002C0918
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(491) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL LowestValidUsn  = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(492) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL MaxUsn          = 0x7FFFFFFFFFFFFFFF
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(493) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL MaximumSize     = 0x0000000012C00000
    13B0 1194 09/10 06:19:04.199 18 usnjournalhelper.cpp(494) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL AllocationDelta = 0x0000000000000000
    13B0 1194 09/10 06:19:04.199 31 filterwrapper.cpp(48) [00000000037DEF70] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB NORMAL Loaded DPMFSFilterWrapperDLL.dll
    13B0 1194 09/10 06:19:04.199 05 fsmtransition.cpp(111) [0000000000ED4180] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] HasEventErrorCode: completion: 0xa10c, signature: 0xaabbcc00
    13B0 1194 09/10 06:19:04.199 31 aasubtask.cpp(906) [0000000000ED1590] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING <?xml version="1.0"?>
    13B0 1194 09/10 06:19:04.199 31 aasubtask.cpp(906) [0000000000ED1590] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING <Status xmlns="http://schemas.microsoft.com/2003/dls/StatusMessages.xsd" StatusCode="-2145452017" Reason="Error" CommandID="RAConfigureDeltaTracking" CommandInstanceID="96fe1088-65f4-4c31-af1b-c8b1eddec4fc" GuidWorkItem="987ecc0f-fc48-41d0-9f17-3007f54d1fef" TETaskInstanceID="615e7bf9-f1f8-4128-a0cf-812bb4f83aeb"><ErrorInfo xmlns="http://schemas.microsoft.com/2003/dls/GenericAgentStatus.xsd" ErrorCode="998" DetailedCode="-2145452017" DetailedSource="2"/><RAStatus><RAConfigureDeltaTracking xmlns="http://schemas.microsoft.com/2003/dls/ArchiveAgent/StatusMessages.xsd"><ConfigureInfo><SqlConfig xmlns="http://schemas.microsoft.com/2003/dls/ArchiveAgent/CommonTypes.xsd"><ScratchSpaceLocation>D:\netdb\Log\DPM_SQL_PROTECT\VM-DBCENTER\netdb_log.ldf</ScratchSpaceLocation><TruncateDbLog>false</TruncateDbLog><VolumeConfig><JournalId>131686028128240638</JournalId><VolumeName>\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\</VolumeName></VolumeConfig></SqlConfig></ConfigureInfo></RAConfigureDeltaTracking></RAStatus></Status>
    13B0 1194 09/10 06:19:04.199 03 runtime.cpp(1392) [000000000099C5D0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB FATAL Subtask failure, sending status response XML=[<?xml version="1.0"?>
    13B0 1194 09/10 06:19:04.199 03 runtime.cpp(1392) [000000000099C5D0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB FATAL <Status xmlns="http://schemas.microsoft.com/2003/dls/StatusMessages.xsd" StatusCode="-2145452017" Reason="Error" CommandID="RAConfigureDeltaTracking" CommandInstanceID="96fe1088-65f4-4c31-af1b-c8b1eddec4fc" GuidWorkItem="987ecc0f-fc48-41d0-9f17-3007f54d1fef" TETaskInstanceID="615e7bf9-f1f8-4128-a0cf-812bb4f83aeb"><ErrorInfo xmlns="http://schemas.microsoft.com/2003/dls/GenericAgentStatus.xsd" ErrorCode="998" DetailedCode="-2145452017" DetailedSource="2"/><RAStatus><RAConfigureDeltaTracking xmlns="http://schemas.microsoft.com/2003/dls/ArchiveAgent/StatusMessages.xsd"><ConfigureInfo><SqlConfig xmlns="http://schemas.microsoft.com/2003/dls/ArchiveAgent/CommonTypes.xsd"><ScratchSpaceLocation>D:\netdb\Log\DPM_SQL_PROTECT\VM-DBCENTER\netdb_log.ldf</ScratchSpaceLocation><TruncateDbLog>false</TruncateDbLog><VolumeConfig><JournalId>131686028128240638</JournalId><VolumeName>\\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\</VolumeName></VolumeConfig></SqlConfig></ConfigureInfo></RAConfigureDeltaTracking></RAStatus></Status>
    13B0 1194 09/10 06:19:04.199 03 runtime.cpp(1392) [000000000099C5D0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB FATAL ]
    13B0 1194 09/10 06:19:04.230 31 filterwrapper.cpp(302) [0000000000ED54D0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : Volume Name = \??\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\
    13B0 1194 09/10 06:19:04.230 31 filterwrapper.cpp(81) [0000000000ED54D0] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : Encountered Failure: : lVal : EnsureFilterIsAttached(strVolume)
    13B0 1194 09/10 06:19:04.230 31 configuredeltasubtask.cpp(587) [0000000000ED1590] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : Volume Name = \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\
    13B0 1194 09/10 06:19:04.230 31 configuredeltasubtask.cpp(405) [0000000000ED1590] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : VolumePath \\?\Volume{6c632aa3-2069-47ba-b4fc-fbeb45b2e22e}\
    13B0 1194 09/10 06:19:04.230 05 fsmstate.cpp(167) [0000000000ED2570] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : Encountered Failure: : lVal : pTransition->Execute(pEvent)
    13B0 1194 09/10 06:19:04.230 05 genericfsm.cpp(225) [0000000000EBAE10] 615E7BF9-F1F8-4128-A0CF-812BB4F83AEB WARNING Failed: Hr: = [0x801f000f] : Encountered Failure: : lVal : m_pCurrentState->SendEvent(pEvent, pNextState)


    北京老马

    Monday, September 10, 2018 6:36 AM

Answers

  • Okay, there's the problem, this is why you are getting this error, if you are planning to use ReFS File System for Databases and Logs then you can’t use DPM for backup I'm afraid.

    Do you have the possibility to create a NTFS disk and move the database backups there?



    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by Martin.ma Wednesday, September 12, 2018 8:23 AM
    Wednesday, September 12, 2018 7:50 AM

All replies

  • Hi!

    Could you describe more in detail how your SQL Server is set up?

    Do you mean that you have a SQL Server 2012 that has the data and log on separate disks/volumes?
    Are they on located on the SQL Server itself or remotely?


    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, September 10, 2018 6:50 AM
  • Thank you very much first.

    Each database uses the separate folder to store data and logs,they are all on the local disk.

    Best Regards

    Martin


    北京老马

    Monday, September 10, 2018 7:03 AM
  • The different locations where the data or logs is stored doesn't matter for DPM.

    If you want to backup an SQL Server (instances) you simply:

    1. Create a new Protection Group / Modify existing Protection Group.
    2. In the Select Protection Group Type, select Servers.
    3. In Select Group Members, select the SQL Server instances on the server you want to protect.

    You have the option of selecting protection at the instance level or protection of individual databases (see picture below).


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, September 10, 2018 7:52 AM
  • I did the same, but failed, the database of the root directory is no problem, but the database of other paths failed, the recovery point could not be created, and the consistency check failed.

    By the way, the database's logs and data files also are in different folders.


    北京老马

    Monday, September 10, 2018 8:10 AM
  • Do you have any other database/instance on your D-drive? Also was this database/instance added later on?

    Also what does the Critical/error say in the Monitoring pane on the left in your DPM console?


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Monday, September 10, 2018 8:47 AM
    Monday, September 10, 2018 8:43 AM
  • yes, there are other databases, but the same error will occur.

    北京老马

    Monday, September 10, 2018 9:17 AM
  • Could you provide the detailed error message here?

    Also make sure the DPMRA account has sa permissions on the database/instance.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, September 10, 2018 9:20 AM
  • Hi Leon,

    Thank you again.

    Because the error language is a Chinese interface,I translated it with software. 

    I confirm that the DPMRA account has database/instance administrator privileges.  The client error log please refer to the first post.

    Affected area: VM-DBCENTER\ViaNetFileDB

    Date of occurrence: 2018/9/10 14:25:11

    Description: VM-DBCenter.service.com SQL Server 2012 database VM - DBCENTER \ ViaNetFileDB copy do not agree with the protected data sources.All protection operations for the data source will fail before synchronization with a consistency check on the copy.You can recover data from an existing recovery point, but you cannot create a new recovery point until the copies are consistent.

    For SharePoint fields, you can continue to create recovery points for consistent databases.To back up an inconsistent database, run the consistency check on the field.(ID 3106).

    An unexpected error occurred while running the job.(ID 104 details: do not attach filters to volumes at this time.X801f000f (0))

    The detailed information

    Recommended operation: please try this operation again.

    Do synchronization with consistency check.

    Run synchronization jobs with consistency checks...

    Solution: to stop the alarm, click below

    disable



    北京老马

    Tuesday, September 11, 2018 2:38 AM
  • May I ask what storage are you using? And how is it formated NTFS/ReFS?

    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, September 11, 2018 6:23 AM
  • I use the local disk of Hyper-V,and the partition format is NTFS.

    北京老马

    Tuesday, September 11, 2018 6:35 AM
  • Is this a specific database server or is this an instance that is on the same database server as another one that is already in DPM and working?

    Can you try to remove it from the protection group with the retain data option and then re-add it?


    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, September 11, 2018 9:07 AM
  • this is working server , the database backup of the default path location is normal, these database backups stored on Drive-D have been unsuccessful, and they are all the same instance.

    I tried everything you said, but it still failed.


    北京老马

    Wednesday, September 12, 2018 6:57 AM
  • These database backups that are stored on the D-drive, how are they formated? NTFS / ReFS?

    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, September 12, 2018 7:08 AM
  • the D-Drive format is ReFs.

    北京老马

    Wednesday, September 12, 2018 7:44 AM
  • Okay, there's the problem, this is why you are getting this error, if you are planning to use ReFS File System for Databases and Logs then you can’t use DPM for backup I'm afraid.

    Do you have the possibility to create a NTFS disk and move the database backups there?



    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by Martin.ma Wednesday, September 12, 2018 8:23 AM
    Wednesday, September 12, 2018 7:50 AM
  • I will try to change the partition format, thanks again. 

    I will close the post. 

    Best Regards


    北京老马

    Wednesday, September 12, 2018 8:23 AM
  • You're welcome and good luck!

    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, September 12, 2018 8:41 AM