Veritas-bu

Re: [Veritas-bu] open files to be backed up

2010-03-22 10:04:04
Subject: Re: [Veritas-bu] open files to be backed up
From: "Martin, Jonathan" <JMARTI05 AT intersil DOT com>
To: <VERITAS-BU AT mailman.eng.auburn DOT edu>
Date: Mon, 22 Mar 2010 10:03:52 -0400

Didn’t Curtis’ book include some information on backing up databases without the database agent?

 

I was waiting for the plug. =P

 

-Jonathan

 

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of SACHIN ARORA
Sent: Saturday, March 20, 2010 11:01 AM
To: Justin Piszcz
Cc: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] open files to be backed up

 

Thanks for replying...

 

 Hovewer, i'm kinda illetrate in this...can you elaborate "you need a connector to backup databases"

 Can't these filed be backed up via open file file backup (VSS/VSP)

 

Regards

Sachin



 

On Sat, Mar 20, 2010 at 9:52 AM, Justin Piszcz <jpiszcz AT lucidpixels DOT com> wrote:

Hi,

MDF is a SQL Server Express DB file, you will have problems backing them up if they keep changing when you back them up.  Usually you need a connector to backup databases.

Justin.



On Sat, 20 Mar 2010, SACHIN ARORA wrote:

Hi All,

I have a small issue here :


Backup of one of the server is getting partially successfull

Master : Solaris 10 , netbackup 6.5.4
Client : window 2003 , netbackup 6.5.4

Here the files that are not getting backed up :

03/19/2010 21:31:38 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL
Server\MSSQL\Data\Audit_DB_Data.MDF (WIN32 32: The process cannot access the
file because it is being used by another process. )
03/19/2010 21:31:39 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\Audit_DB_Log.LDF
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:40 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\crnmr4_Data.MDF
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:41 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\crnmr4_Log.LDF
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:41 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:42 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:43 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf (WIN32
32: The process cannot access the file because it is being used by another
process. )
03/19/2010 21:31:44 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:45 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:31:46 - Warning bpbrm (pid=14837) from client : WRN - can't
open file: D:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
(WIN32 32: The process cannot access the file because it is being used by
another process. )
03/19/2010 21:59:29 - end writing; write time: 0:58:17
the requested operation was partially successful (1)

I want these files to be backed up. I tried
Disabled Open file backup and refired backup - -- still didnot backup these
files
Selcted -- Enabled VSP , Individual drive snapshot, Abort on error --
refired backup -- still didnot backup these files
Selcted -- Enabled VSS , Individual drive snapshot, Abort on error --
refired backup -- still didnot backup these files

Can sombody help me how to get these files to be backed up. its a production
server , need to fix this quickly

Thanks
Sachin

 

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu