cancel
Showing results for 
Search instead for 
Did you mean: 

Host Sql Server backups

BackupSysAdmin
Level 4

I am having an issue with the backup of one of the servers that host my SQL servers.  This server is running Windows 2003, SQL 2005, and Netbackup 7.0.1.  The problem is that I am backing up the Server (clustered), meaning all drives.  It appears that the backup of file on one of the network drives is not being completed.  There are several files that give the error "The process cannot access the fie because it is being used by another process".  The files in questions are sql database files.  The error logs are below.  I am actually backing up the SQL database using Netbackup SQL scripts directly to tape, so I am wondering if I should be concerned.  Any assistance would be appreciated.

5/23/2012 9:26:27 PM - Info bpbrm(pid=6728) from client Abcd1234: TRV - object not found for file system backup: I:
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\DES_20111209.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\DES_20111209.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\master.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\mastlog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\model.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\modellog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\msdbdata.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:58 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\msdblog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:59 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\tempdb.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:59 PM - Warning bpbrm(pid=6728) from client Abcd1234: WRN - can't open file: E:\Microsoft SQL Server\MSSQL.4\MSSQL\Data\templog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
5/23/2012 9:26:59 PM - Info bpbrm(pid=6728) from client Abcd1234: TRV - last message being suppressed after 10 occurrences
5/24/2012 5:45:11 AM - Info bpbrm(pid=6728) from client Abcd1234: TRV - object not found for file system backup: X:
5/24/2012 5:45:24 AM - end writing; write time: 08:24:42
the requested operation was partially successful(1)

1 ACCEPTED SOLUTION

Accepted Solutions

Will_Restore
Level 6

exclude those database files from OS filesystem backups

 

 

URL http://www.symantec.com/docs/TECH52558

 

Solution

 

To prevent Windows file system backups on a Microsoft SQL Server from exiting with a NetBackup Status Code 1 (the requested operation was partially successful), it is necessary to create an exclude list for the MS-Windows policy to exclude the database files.  

The SQL database files have three different file extensions: .mdf, .ndf, .ldf.  When creating the exclude list, be sure to exclude these three file types from the file system backup policy.

 

View solution in original post

2 REPLIES 2

Will_Restore
Level 6

exclude those database files from OS filesystem backups

 

 

URL http://www.symantec.com/docs/TECH52558

 

Solution

 

To prevent Windows file system backups on a Microsoft SQL Server from exiting with a NetBackup Status Code 1 (the requested operation was partially successful), it is necessary to create an exclude list for the MS-Windows policy to exclude the database files.  

The SQL database files have three different file extensions: .mdf, .ndf, .ldf.  When creating the exclude list, be sure to exclude these three file types from the file system backup policy.

 

Andy_Welburn
Level 6

I have *never* seen that T/N! surprise