NetApp SnapProtect tips are welcome

• gkramer 23701

  Ten Centuries

  Points: 1381

  More actions

  December 2, 2014 at 8:48 am

  #301583

  Hi,

  As a DBA I just started at a new firm where they use NetApp SnapProtect for backing-up databases

  and as a 'old skool' DBA I have to reshuffle some old habbits and customs.....

  Backing up a 250 GB database is done withing 2 minutes time (using a snapshot method on SAN) but I wonder what's the catch ????

  During this snap-period I noticed the folowing error in the errorlog;

  ** I/O is frozen on database HHHH. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.

  and direct afterwards - this message;

  ** I/O was resumed on database HHHH. No user action is required.

  Followed by;

  **Database backed up. Database: HHHH, creation date(time): 2014/10/30(16:01:39), pages dumped: 379, first LSN: 3145:160:72, last LSN: 3145:200:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{F25636F7-332E-476A-931F-31E5A8E966C8}28'}). This is an informational message only. No user action is required.

  often follwed by an extra error-message (SQL ERROR 995);

  ** BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_E7B42381-737C-4670-81FD-B4A6B766481206'

  This makes me curious what is actualy happening within SQL Server (2005/2008/2012)......

  Can anyone give me hints and tips using SnapProtect for backing up and/or restoring databases?

  Regards,

  Guus Kramer

  The Netherlands