none
DPM and SQL 2005 VSS issues? RRS feed

  • Question

  • Hello,

    Twice a day during the DPM Backups users could not access anymore the applications...
    I noticed in the SQL logs these errors:

    http://troubleshootingsql.wordpress.com/2010/01/06/io-frozen-messages-while-taking-nt-backup-for-sql-databases/

    http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b951288

    08/02/2010 05:36:28,spid106,Unknown,I/O was resumed on database FDB_OrderView_20091106. No user action is required.
    08/02/2010 05:36:28,spid106,Unknown,I/O is frozen on database FDB_OrderView_20091106. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:35:41,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2010/06/22(06:38:01)<c/> pages dumped: 1<c/> first LSN: 2902:280:37<c/> last LSN: 2902:304:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{09D5F68B-F1ED-4B48-9FF1-D081C678A56B}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:35:40,spid106,Unknown,I/O was resumed on database master. No user action is required.
    08/02/2010 05:35:40,spid106,Unknown,I/O is frozen on database master. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:34:56,Backup,Unknown,Database backed up. Database: ReportServerTempDB<c/> creation date(time): 2008/02/21(10:24:41)<c/> pages dumped: 1<c/> first LSN: 342:323:37<c/> last LSN: 342:339:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{43DF9404-2459-4E30-B28E-144D0C879483}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:34:56,spid164,Unknown,I/O was resumed on database ReportServerTempDB. No user action is required.
    08/02/2010 05:34:56,spid164,Unknown,I/O is frozen on database ReportServerTempDB. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:34:13,Backup,Unknown,Database backed up. Database: ReportServer<c/> creation date(time): 2008/02/21(10:24:40)<c/> pages dumped: 1<c/> first LSN: 224:85:37<c/> last LSN: 224:101:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{BE633AB6-29A8-49F2-A3D8-4B2727847388}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:34:12,spid164,Unknown,I/O was resumed on database ReportServer. No user action is required.
    08/02/2010 05:34:12,spid164,Unknown,I/O is frozen on database ReportServer. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:33:27,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 1<c/> first LSN: 215:2368:37<c/> last LSN: 215:2392:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{1F0249D6-F023-487E-B701-2BC54134313C}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:33:26,spid164,Unknown,I/O was resumed on database model. No user action is required.
    08/02/2010 05:33:26,spid164,Unknown,I/O is frozen on database model. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:31:42,Backup,Unknown,Database backed up. Database: CA_LosAngeles_UCLAMedicalCenter_Reagan_EDMS<c/> creation date(time): 2009/05/14(07:35:15)<c/> pages dumped: 1<c/> first LSN: 306387:6654:154<c/> last LSN: 306387:6718:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{51B2DCEE-F371-482F-8AE1-24787B254CFA}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:31:41,spid164,Unknown,I/O was resumed on database CA_LosAngeles_UCLAMedicalCenter_Reagan_EDMS. No user action is required.
    08/02/2010 05:31:41,spid164,Unknown,I/O is frozen on database CA_LosAngeles_UCLAMedicalCenter_Reagan_EDMS. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:30:53,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1<c/> first LSN: 88691:264:219<c/> last LSN: 88691:360:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{B8384534-CCC6-40A9-8310-97EABC4C7662}1'}). This is an informational message only. No user action is required.
    08/02/2010 05:30:52,spid164,Unknown,I/O was resumed on database msdb. No user action is required.
    08/02/2010 05:30:52,spid164,Unknown,I/O is frozen on database msdb. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    08/02/2010 05:30:00,Backup,Unknown,Log was backed up. Database: CA_LosAngeles_UCLAMedicalCenter_Reagan_EDMS<c/> creation date(time): 2009/05/14(07:35:15)<c/> first LSN: 306380:8489:1<c/> last LSN: 306387:5872:1<c/> number of dump devices: 1<c/> device information: (FILE=2<c/> TYPE=DISK: {'EDMS'}). This is an informational message only. No user action is required.

    Any idea how to fix this as it seems to be the issue isn't it?

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    • Moved by Parag Agrawal Wednesday, August 4, 2010 10:11 AM thread relates to SQL VSS issue (From:Data Protection Manager)
    Monday, August 2, 2010 7:47 PM

Answers

  • Hi Dom,

     

    Yes, However, this is not something that DPM has any control over.

    DPM requires that snapshots be taken of the volumes that the databases reside on. Are their any VSS errors in the Applicaton event log, or Volsnap errors in the system event log ?   Are the backups completing OK, but only the users cannot access the DB's during a backup ?

    You may want to look at CPU resources / Memory usage and also Disk I/O while backups are performed to see if you have some kind of bottleneck that needs to be addressed. 

     


    Regards, Mike J [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, August 2, 2010 10:53 PM
    Moderator

All replies

  • Hi Dom,

     

    Yes, However, this is not something that DPM has any control over.

    DPM requires that snapshots be taken of the volumes that the databases reside on. Are their any VSS errors in the Applicaton event log, or Volsnap errors in the system event log ?   Are the backups completing OK, but only the users cannot access the DB's during a backup ?

    You may want to look at CPU resources / Memory usage and also Disk I/O while backups are performed to see if you have some kind of bottleneck that needs to be addressed. 

     


    Regards, Mike J [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, August 2, 2010 10:53 PM
    Moderator
  • Hi Mike.

    Are they any VSS errors in the Applicaton event log?  No
    Are they Volsnap errors in the system event log?  No
    Are the backups completing OK?     98% YES
    Only the users cannot access the DB's during a backup ? Yes
    I will check tonight the CPU resources/Memroy usage and Disk I/O during the backup.

    but this article seems to show a known issue with VSS shared between NTBackup and SQL 2005?

    http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b951288

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Monday, August 2, 2010 11:08 PM
  • Hi Felyjos!

    What service pack level does your SQL2005 have? Upgrade to the latest SP and try again. Does your SQL have any local backup jobs running at any time? If so disable those, this will mess upp the transactionlogs for DPM.


    Check out my DPM blog @ http://robertanddpm.blogspot.com
    Tuesday, August 3, 2010 8:45 PM
    Moderator
  • Hi Robert,

    I have the errors on two servers I checked so far:

    SQL 2000 SP4

    SQL 2005 SP2

    Yes we have log backups running every 30 minutes. So far we have done two steps:

    - Stop DPM on one server and there is no more I/O error

    - Stop the backup jobs on the other server and the I/O errors remain.

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Tuesday, August 3, 2010 9:14 PM