Re: [Veritas-bu] open files to be backed up
2010-03-22 10:48:18
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
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
|
|
|