cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup and SQL 2005 - ndf files

Bob_Wala
Level 3
Hi,

We have SQL 2005 (SP3 CU3) and use Netbackup (v6 MP4) to backup the sql files to tape.

There are about 16 databases with SQL primary, secondary and log files on different drives on SQL server.
These database files are copied on to Backup servers using snap software successfully.

The files then get backed up to tape from the Backup server.
 However the problem is that about ten *.ndf files will not get backed up on to tape - Status Code 1: incomplete backup....  The only way around it is to reboot the Backup server and re-run the tape job policy - all files get backed up.

Has anyone come across this kind of behaviour whereby Netbackup  fails to back up some *.ndf files?

Many thanks

Bob
6 REPLIES 6

sql_noob
Level 4
are you using the SQL agent to back these up? if the database is mounted then the files are in use and it's a PITA to back them up

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
What is the actual reason in Details tab for skipping the ndf files?

Bob_Wala
Level 3
Thanks for your replies...

We dont use SQL agent to back these files, once a snapshot of the SQL data is on the backup server, it is backed up directly using a netbackup policy as flat files, not connected at this point. Problem started when SQL was upgraded from 2000 to SQL2005.

Actual error in detail tab is:
<Date> Error bpbrm(pid=676) from client <backup server>: ERR - failure reading file: F:\<copy folder>\<SQL Instance>\Program Files\Microsoft SQL Server\Data\DATA_1.ndf (WIN32 1450: Unknown error)

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Was hoping there would be something more useful than "Unknown error"...  The fact that it's working fine after a reboot might mean that some process is still holding on to it, but then I would expect a WIN32 message saying that.
Are you able to run ProcessExplorer at the time the file is getting skipped?

Bob_Wala
Level 3
Unfortunately there is no ProcessExplorer (it would have to be authorised to be put on the system etc).
However what i have tried is backing up the drive containing ndf files directly from the SQL server onto tape and this too gave a similar result whereby some of the ndf files were skipped with the same error as above. (WIN32 1450: Unknown error)

Regards

Bob_Wala
Level 3

this was sorted by changing a setting in the registry to allow backup of large files as described in :

http://support.microsoft.com/kb/304101/en-us

  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type PoolUsageMaximum as the entry name, and then press ENTER.
  5. Right-click PoolUsageMaximum, and then click Modify.
  6. Click Decimal.
  7. In the Value data box, type 60, and then click OK.