Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lauri332
Starting Member
9 Posts |
 Posted - 2008-10-08 : 07:49:00
|
| Hi again,I've got a problem with the backup. We are using Netbackup and W2k3. The following error occurs:Warning bpbrm(pid=4620) from client s3411: WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )08.10.2008 11:18:35 - Warning bpbrm(pid=4620) from client s3411: WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mastlog.ldf (WIN32 32: The process cannot access the file because it is being used by another process. )08.10.2008 11:18:35 - Warning bpbrm(pid=4620) from client s3411: WRN - can't open file: D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\model.mdf (WIN32 32: The process cannot access the file because it is being used by another process. )Anyone know how I can fix this problem and what the problems could be?Would be very nice!Lauri |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-08 : 08:26:25
|
| Does it have proper permission to backup? |
 |
|
|
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2008-10-08 : 09:14:58
|
| We are using Netbackup as well. The thing is that you should not try and backup the MDF, NDF, and LDF files. Evidently these files are going to be in use by the SQL Server at all times as long as the database is attached.We are actually using NET Backup "SQL Agent" to do a backup to tape and this actually just use the SQL Agent API to do the backups which are logged in the SQL Server logs. If you don't have the ability to do SQL backups within NET Backup you will want to continue to do Full, Differential, Transaction log backup to your local system as necessary and then use NET Backup to backup these files to TAPE.I don't manage NET Backup per se' but we add MDF, NDF, and LDF to exclude list and they don't be backed up. You will need to read the NETBackup documentation to determine how you do this. |
|
|
|
Lauri332
Starting Member
9 Posts |
Posted - 2008-10-08 : 09:28:29
|
| Hi...thx for your answers. The permissions shouldn't be the problem.We have installed the Netbackup MS SQL Client on the server. Is this what you mean with SQL Agent?Lauri |
|
|
|
ddamico
Yak Posting Veteran
76 Posts |
Posted - 2008-10-08 : 10:03:22
|
| Yes, MS SQL client.The short answer is you shouldn't try to backup MDF,NDF, or LDF these should be added as exclusions to your policy. This is how we handle it your errors will go away1. Use MS SQL Client to backup to Tape (Virtual device)2. Use SQL Backups locally and then use NET Backup to backup the .BAK and .TRN files. |
|
|
|
Lauri332
Starting Member
9 Posts |
Posted - 2008-10-09 : 05:01:06
|
| Hi again,is it also possible to backup the database files by using the export function of SQL Server? (After export I would backup it normally with Netbackup)Lauri |
|
|
|
|
|
|
|
|
Backup Problems