Forum Discussion

lucasnb's avatar
lucasnb
Level 3
11 years ago
Solved

Snapshot in environment with mount point

Hello people,

I need your help! I have one server with partition with cross mount point. I read in forum technet that server with cross mount point don't enable VSS Shadow Copy. Follow link -> http://technet.microsoft.com/en-us/library/cc753975.aspx

But the in detailed status on Netbackup shows:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

11/08/2014 04:39:47 - Info bpbkar32(pid=41596) Backup started           
11/08/2014 04:39:47 - Info bpbrm(pid=27656) Sending the file list to the client      
11/08/2014 04:40:21 - Info bptm(pid=29124) media id AA0212 mounted on drive index 8, drivepath {7,0,7,0}, drivename Drive018, copy 1
11/08/2014 04:40:21 - mounted; mount time: 00:00:56
11/08/2014 04:40:27 - positioning AA0212 to file 28
11/08/2014 04:42:11 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup01\FULL_HMSVC02>       
11/08/2014 04:42:35 - positioned AA0212; position time: 00:02:08
11/08/2014 04:42:35 - begin writing
11/08/2014 04:43:08 - Error bpbrm(pid=27656) from client srv10142hml: ERR - failure reading file: S:\Disk_Backup01\FULL_HMSVC02\BKPFULL_TFS_TPC-2008_24052013_PRD_20140810_01_DE_03.BAK (WIN32 2: Unknown error)
11/08/2014 04:43:09 - Warning bpbrm(pid=27656) from client srv10142hml: WRN - Snapshot Error: will continue backup without any volume snapshots
11/08/2014 04:43:09 - Error bpbrm(pid=27656) from client srv10142hml: ERR - Snapshot Error while reading file: GLOBALROOT\Device\HarddiskVolumeShadowCopy864\FULL_HMSVC02\BKPFULL_TFS_TPC-2008_24052013_PRD_20140810_01_DE_03.BAK  
11/08/2014 05:38:45 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup01\DIFF_HMSVC02>       
11/08/2014 05:38:45 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup01\LOG_HMSVC02>       
11/08/2014 05:38:45 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup02\FULL_HMSVC02>       
11/08/2014 06:44:46 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup02\DIFF_HMSVC02>       
11/08/2014 06:44:46 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup02\LOG_HMSVC02>       
11/08/2014 06:45:04 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup03\FULL_HMSVC02>       
11/08/2014 07:33:44 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup03\DIFF_HMSVC02>       
11/08/2014 07:33:44 - Info bpbkar32(pid=41596) change journal NOT enabled for <S:\Disk_Backup03\LOG_HMSVC02>       
11/08/2014 07:33:52 - Info bpbrm(pid=29180) media manager for backup id srv10142hml_1407742743 exited with status 0: the requested operation was successfully completed
11/08/2014 07:33:53 - Info bpbrm(pid=29180) child done, status 1         
11/08/2014 07:33:53 - end writing; write time: 02:51:18
the requested operation was partially successful(1)

The job was successfully completed, but some files may have been
busy or unaccessible. See the problems report or the client's logs for more details.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I thought this error were because the snapshot don't enable in partition but how I said in begin, don't active VSS on partition with mount point. All right?

I've just looked in configuration of policy and the option of "cross mount point" is flag. I don't know more to do. Sorry for my english.

7.5
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Michael_G_Ander's avatar
    Michael_G_Ander
    11 years ago

    Think the problem is that the database backup to disk is still running, when netbackup is trying to read the .bak file. Move one of the backups so the database is finished when the Netbackup backup starts.

    Assume there is a reason you are not using a SQL agent backup for this database.

    Hope this helps

  • INT_RND's avatar
    INT_RND
    Level 6
    11 years ago

    You cannot backup a database file reliably as a flat file using filesystem backups.

    Is this file a database or database backup?

    S:\Disk_Backup01\FULL_HMSVC02\BKPFULL_TFS_TPC-2008_24052013_PRD_20140810_01_DE_03.BAK 

     

    If it is an active database or backup then you will need to exclude this file from the filesystem backup and use a proper database policy type to perform the database backup.

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    11 years ago

    Hello,

     

    I think you've misunderstood the technet article. They are referring to FOLDER mount points i.e when you take a lun and mount it on S:\Disk Backup01 or S:\Disk Backup02. Is that what you've done? Or is S:\ a lun by itself?

     

    Please post the policy that you're using (bppllist "policy name" -U)

     

    Enable the BPFIS log on the client and rerun the job. Then share the log.

  • Michael_G_Ander's avatar
    Michael_G_Ander
    Level 6
    11 years ago

    Think the problem is that the database backup to disk is still running, when netbackup is trying to read the .bak file. Move one of the backups so the database is finished when the Netbackup backup starts.

    Assume there is a reason you are not using a SQL agent backup for this database.

    Hope this helps

  • lucasnb's avatar
    lucasnb
    Level 3
    11 years ago

    Hi everybody, thanks by share your comments!

    INT_RND this file its only database backup not a database archive. I think it's not necessary change the type of policy, because it's SQL generate this archive.

     

    Riaan, I have three LUN's and these LUN's are mounted on S:\ partition. I'll run the policy again and share the log with you.

     

    Michael probably it is, I'll contact the DBA team to know which is better hour to backup these archives.

     

    Thanks for forward my question.

     

  • INT_RND's avatar
    INT_RND
    Level 6
    11 years ago

    Using the database connector to perform the backup is more reliable because the amount of time it takes to write the BAK file will be slightly different every day. The database backup types were created specifically to solve this type of problem where you need to time the start of a backup with the end of a database dump.

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    11 years ago

    Did you mount 1 lun on each folder? Then the VSS limitation might apply. Try mounting the luns on S:\ T:\ U:\

  • Marianne's avatar
    Marianne
    Level 6
    11 years ago

    You can use the NBU agent for SQL to backup databases directly to tape.
    Single pass backup and single pass restore.

    With database backups to disk, you and dba's will always have to try and co-ordinate backup times.
    This requires a 2-step backup process and a 2-step restore, with the additional headache of disk cleanup to ensure there is always space for these disk backups.

  • INT_RND's avatar
    INT_RND
    Level 6
    11 years ago

    Did you fix the problem?

    Please mark the solution so other people know which post you found helpful.