Snapshot in environment with mount point

[lucasnb]

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.

[INT_RND]

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]

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 · Accepted solution]

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]

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]

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]

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

[Marianne]

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.

[lucasnb]

Hello people, thanks again!

[INT_RND]

Did you fix the problem?

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