10-06-2013 07:18 PM
i got problem below when backup sqlserver with Symantec netbackup 7.1 :
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\distribution.MDF (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\EFB.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\EFB_1.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\model.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\modellog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Warning bpbrm(pid=6544) from client 10.1.6.238: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )
10/7/2013 8:06:56 AM - Info bpbrm(pid=6544) from client 10.1.6.238: TRV - last message being suppressed aft
Could you give me some advice for issue ?
Solved! Go to Solution.
10-06-2013 09:55 PM
You need to exclude SQL data file (*.mdf, *.ldf, etc) from MS-Windows backup.
Use NBU agent to backup SQL databases or else SQL built-in backup tool to backup databases to disk which will be included in MS-Windows backup.
10-06-2013 08:28 PM
Hi
You should backup sql server by netbackup for sql agent.
If you want to backup database files,you can stop sql server first ,then backup all the data files.
10-06-2013 09:55 PM
You need to exclude SQL data file (*.mdf, *.ldf, etc) from MS-Windows backup.
Use NBU agent to backup SQL databases or else SQL built-in backup tool to backup databases to disk which will be included in MS-Windows backup.
10-06-2013 11:14 PM
10-21-2013 04:30 AM
Use Netbackup SQL Agent utility to take Microsoft SQL server databases.
10-30-2013 08:13 AM
If you do not want use the SQL agent for some reason, set up a maintenance plan in the SQL server to run backup to disk and backup the resulting files with Netbackup.
Cannot recommend it as you get a more complex and probably longer restore/recovery process