Re: [Veritas-bu] open files to be backed up
2010-03-22 11:46:54
I think the technical terms for this is Cold Backup which
requires the database to be stopped before backup. Hot Backup is when
there is an agent or some other software that doesn’t shut down the
database, and instead takes a snapshot in a point of time while data can be
written still after snapshot.
Dustin D'Amour
Wireless Switch Technician
Plateau Wireless
575.389.4189 - office
575.309.6372 - cell
dustind AT plateautel DOT com
(\_/)
(O.o)
(> <)
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 9:20 AM
To: Lightner, Jeff; VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] open files to be backed up
The keyword in your statement is "down". You can backup
any database that is down, their just regular files. It's while the database is
running that the problem arises.
Regards,
Patrick Whelan
NetBackup Specialist
Wholesale Markets and
Treasury & Trading
Lloyds Banking Group
Desk: +44 (0) 207 158 6123
Loc: OBS 2C-132
From: Lightner, Jeff [mailto:jlightner AT water DOT com]
Sent: 22 March 2010 14:37
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 has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
|
_______________________________________________
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
|
|
|