Right - wasn't saying it was the best way to do things - just that it
could be done.   

 

Here we actually do backups of filesystem mounts of BCV copies of our
main Production (Oracle) DB so don't have to take it down.  

 

We do have a couple of large ancillary DBs such as data warehouse that
can be taken down over weekends so do backups directly from those.

 

I just wasn't sure if it was possible on Windows SQL stuff as I don't
really look at it myself.

 

________________________________

From: WEAVER, Simon (external) [mailto:simon.wea...@astrium.eads.net] 
Sent: Monday, March 22, 2010 10:48 AM
To: Lightner, Jeff; Whelan, Patrick; VERITAS-BU@mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] open files to be backed up

 

You can take SQL down (stop the services) - run backup to perform a
"file level" backup, but when you got a 24 x 7 environment, this is not
practical.

 

Best method is to get your SQL Admin to backup the Databased to Disk,
using the built in SQL Backup tool or get the MS-SQL-Server Agent option
license, and apply to your NetBackup environment.

 

Live Database files, or even Personal Email folders that are in use
(like .pst files) cannot be touched correctly.

Once you have got a decent backup of your SQL Files, I would EXCLUDE the
files that NetBackup cannot touch, therefore giving you a STATUS 0 for
your job, rather than STATUS 1 and reporting the same files being
skipped.

 

Sachin - VSP / VSS would not help in this occasion (same as Oracle, SAP,
Exchange, SQL, ect). 

 

Anyhow, get your SQL DBA Administrator to configure the backups inside
SQL Server Express (or Standard, enterprise) and go from there.

 

Regards

Simon

 

________________________________

From: veritas-bu-boun...@mailman.eng.auburn.edu
[mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of
Lightner, Jeff
Sent: Monday, March 22, 2010 2:37 PM
To: Whelan, Patrick; VERITAS-BU@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] open files to be backed up

I don't know how it works on Windows since we use the SQL agents but on
UNIX/Linux you can backup database files from the filesystem so long as
the database is down at the time you do it.  You can then restore from
that backup to the same filesystems or to an alternate server and/or
filesystems.

________________________________

From: veritas-bu-boun...@mailman.eng.auburn.edu
[mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Whelan,
Patrick
Sent: Monday, March 22, 2010 10:10 AM
To: VERITAS-BU@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] open files to be backed up

It's not a matter of whether you can or can not backup an open file,
it's the type of open file that you are backing up. If it is a database
file and the database isn't aware that you are backing up its file the
file will not be in a state that the database can use if/when you
restore it. MOST database consist of more than one file so the current
file that is being backed up will be in one state whereas the next file
will be in a different state and so on. So that when the files are
restored they will all be in different "positions" and the database
won't know how to reconcile that difference. Database can be backed up
without agents but the database must be in control of the backup in
order to insure a stable environment for the restore. I hope this makes
sense.

Regards, 

Patrick Whelan 
NetBackup Specialist 
Wholesale Markets and Treasury & Trading 
Lloyds Banking Group 
Desk: +44 (0) 207 158 6123 
Loc: OBS 2C-132 

________________________________

From: veritas-bu-boun...@mailman.eng.auburn.edu
[mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Martin,
Jonathan
Sent: 22 March 2010 14:04
To: VERITAS-BU@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] open files to be backed up

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-boun...@mailman.eng.auburn.edu
[mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of SACHIN
ARORA
Sent: Saturday, March 20, 2010 11:01 AM
To: Justin Piszcz
Cc: VERITAS-BU@mailman.eng.auburn.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 <jpis...@lucidpixels.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



This e-mail is private and confidential and may contain privileged
material. If you have received this e-mail in error, please notify the
sender and delete it immediately. You must not copy, distribute,
disclose or use any of the information in it or any attachments.

Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1
1YZ. Registered in Scotland, number 95000. Telephone: 0131 225 4555.

Lloyds TSB Bank plc. Registered Office: 25 Gresham Street, London EC2V
7HN. Registered in England and Wales, number 2065. Telephone: 020 7626
1500.

Lloyds TSB Scotland plc. Registered Office: Henry Duncan House, 120
George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237.
Telephone: 0131 225 4555.

Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester
GL4 3RL. Registered in England and Wales, number 2299428. Telephone:
01452 372372.

Cheltenham & Gloucester Savings is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, Lloyds TSB Scotland plc and Cheltenham & Gloucester
plc are authorised and regulated by the Financial Services Authority.

Telephone calls may be monitored or recorded.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

 

Proud partner. Susan G. Komen for the Cure. 

 

Please consider our environment before printing this e-mail or
attachments. 

----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or
confidential information and is for the sole use of the intended
recipient(s). If you are not the intended recipient, any disclosure,
copying, distribution, or use of the contents of this information is
prohibited and may be unlawful. If you have received this electronic
transmission in error, please reply immediately to the sender that you
have received the message in error, and delete it. Thank you.
----------------------------------

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Reply via email to