Host Sql Server backups
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)
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.
