Re: [Veritas-bu] open files to be backed up
2010-03-22 10:53:04
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.weaver AT astrium.eads DOT net]
Sent: Monday, March 22, 2010 10:48
AM
To: Lightner, Jeff; Whelan,
Patrick; VERITAS-BU AT mailman.eng.auburn DOT 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-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Lightner, Jeff
Sent: Monday, March 22, 2010 2:37
PM
To: Whelan, Patrick;
VERITAS-BU AT mailman.eng.auburn DOT 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-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Whelan, Patrick
Sent: Monday, March 22, 2010 10:10
AM
To:
VERITAS-BU AT mailman.eng.auburn DOT 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-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]
On Behalf Of Martin, Jonathan
Sent: 22 March 2010 14:04
To:
VERITAS-BU AT mailman.eng.auburn DOT 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-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
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)
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
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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] open files to be backed up, SACHIN ARORA
- Re: [Veritas-bu] open files to be backed up, Justin Piszcz
- Re: [Veritas-bu] open files to be backed up, SACHIN ARORA
- Re: [Veritas-bu] open files to be backed up, Ed Wilts
- Re: [Veritas-bu] open files to be backed up, Martin, Jonathan
- Re: [Veritas-bu] open files to be backed up, Whelan, Patrick
- Re: [Veritas-bu] open files to be backed up, Lightner, Jeff
- Re: [Veritas-bu] open files to be backed up, WEAVER, Simon (external)
- Re: [Veritas-bu] open files to be backed up,
Lightner, Jeff <=
- Re: [Veritas-bu] open files to be backed up, Whelan, Patrick
- Re: [Veritas-bu] open files to be backed up, Dustin Damour
- Re: [Veritas-bu] open files to be backed up, Ed Wilts
Re: [Veritas-bu] open files to be backed up, judy_hinchcliffe
|
|
|