Re: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2?
You can also use the dlt, dlt2 and dlt3 drive types. -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Justin Piszcz Sent: Friday, March 19, 2010 9:04 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2? Hi, 'hcart' = lto1/lto4 'hcart2' = lto2 'hcart3' = lto3 While this is cool, I am still waiting for the announcement and pricing on the IBM/Fujitsu(?) 35TB/tape technology. Cool, Just saw this: http://www.storagereview.com/imation_now_shipping_lto_ultrium_generation_5_t ape Imation Now Shipping LTO Ultrium Generation 5 Tape Posted March 19th, 2010 by Brian Imation is starting to ship their next generation tape cartridges, the Imation LTO Ultrium Generation 5. The tape cartridges feature nearly double the storage capacity of the previous generation tape, increased data transfer rates, and a new partitioning functionality. The LTO 5 tape has a native capacity of 1.5TB (3.0TB compressed) and data transfer rates of up to 280 MB/s. Imation LTO Ultrium Generation 5 Other highlights include: * Drive level hardware-based writing of encrypted data to the tape cartridge * Meets compliance objectives with WORM (Write-Once, Read-Many) functionality * Generation 5 drives are are backward-compatible read-and-write capability with the gen4 cartridges, and backward read capabilities with gen3 cartridges * Imation TeraAngstrom technology yields tape with a smoother surface and a high signal-to-noise ratio (SNR) resulting in fewer errors and faster transfer rates * Servo-writing technology allows for precise alignment between drive head and data tracks * Physical tape cartridge features including a patented corner snap and three-piece tape spool More information on Ultirium 5 technology can be found here. Justin. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] 32 KB for BCV Based Tape backup
Hi Forum, My setup has Solaris 10 MASTER/Media on 6.5.5. When an auto schedule of BC Tape backup runs few/all streams of the backup complete by giving 32 KB. BCV devices are made visible to Media server and backup is taken. If we refire the same then it goes well. any clue as to why this happens. I have around 26 BC's but for majority this is the problem. Thanks In Advance. +-- |This was sent by qureshiu...@rediffmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] 32 KB for BCV Based Tape backup
Sounds like the bcv devices are not mounted for the streams that report 32KB. So you are backing up the mount point and not the to be filesystem. len -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of NBU Sent: Monday, March 22, 2010 8:23 AM To: VERITAS-BU@MAILMAN.ENG.AUBURN.EDU Subject: [Veritas-bu] 32 KB for BCV Based Tape backup Hi Forum, My setup has Solaris 10 MASTER/Media on 6.5.5. When an auto schedule of BC Tape backup runs few/all streams of the backup complete by giving 32 KB. BCV devices are made visible to Media server and backup is taken. If we refire the same then it goes well. any clue as to why this happens. I have around 26 BC's but for majority this is the problem. Thanks In Advance. +-- |This was sent by qureshiu...@rediffmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
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 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
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
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
[Veritas-bu] Backup Exec System Recovery Server 2010
All, If anyone out there is using this tool, in conjunction with any other Windows based Backup method, is there a chance they could contact me direct (as I know this product is not really part of this forum). Just wanted to ask a few Q's about this. Regards Simon 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
Re: [Veritas-bu] 32 KB for BCV Based Tape backup
You are probably running the backup before the bcv's are mounted. A backup of 32kb typically is letting you know you just backed up and empty filesystem. We run a script looking for 32k backups to give us a heads up. It's after the fact but it's something that can slip by if not watched for. Wayne BeDour Unix System Administrator PH: 248-447-1739 Internet: wbed...@lear.com -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of NBU Sent: Monday, March 22, 2010 8:23 AM To: VERITAS-BU@MAILMAN.ENG.AUBURN.EDU Subject: [Veritas-bu] 32 KB for BCV Based Tape backup Hi Forum, My setup has Solaris 10 MASTER/Media on 6.5.5. When an auto schedule of BC Tape backup runs few/all streams of the backup complete by giving 32 KB. BCV devices are made visible to Media server and backup is taken. If we refire the same then it goes well. any clue as to why this happens. I have around 26 BC's but for majority this is the problem. Thanks In Advance. +-- |This was sent by qureshiu...@rediffmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ** ** LEGAL DISCLAIMER ** ** This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
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
Re: [Veritas-bu] open files to be backed up
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
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:jlight...@water.com] Sent: 22 March 2010 14:37 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 -
Re: [Veritas-bu] 32 KB for BCV Based Tape backup
On Mon, Mar 22, 2010 at 9:30 AM, BeDour, Wayne wbed...@lear.com wrote: You are probably running the backup before the bcv's are mounted. A backup of 32kb typically is letting you know you just backed up and empty filesystem. We run a script looking for 32k backups to give us a heads up. It's after the fact but it's something that can slip by if not watched for. You can also get a 32k backup if you exclude everything under your mount point. Say you do an ALL_LOCAL_DRIVES backup but exclude something like your live databases so you can run special backups for those. You could get a perfectly valid 32k backup for the original backups. This is similar to the questions we see about status 1 completion codes. For some, it's a problem. For others, it isn't. That's why they pay us the big bucks - to figure out which is which. .../Ed Ed Wilts, RHCE, BCFP, BCSD, SCSP, SCSE ewi...@ewilts.org Linkedin http://www.linkedin.com/in/ewilts ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] open files to be backed up
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 dust...@plateautel.com http://www.linkedin.com/in/ikafx (\_/) (O.o) ( ) 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 9:20 AM To: Lightner, Jeff; VERITAS-BU@mailman.eng.auburn.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:jlight...@water.com] Sent: 22 March 2010 14:37 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
Re: [Veritas-bu] open files to be backed up
On Mon, Mar 22, 2010 at 10:45 AM, Dustin Damour dust...@plateautel.comwrote: 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. The key concepts here are crash-consistent or transactionally-consistent. If you attempt to use a snapshot approach, you'll get a crash-consistent copy. Transactions could be in the middle of being applied and it's possible you'll get half a transaction on disk/tape. This will not make for a clean recovery. Transactionally-consistent database backups are done either through the of host agents, database-specific tools, or shutting down the database. You need to focus the questions on what you want your recovery to look like. Don't focus on the BACKUPS - focus on the RECOVERIES. If you have no plans to recover, don't bother backing it up in the first place. Ed Wilts, RHCE, BCFP, BCSD, SCSP, SCSE ewi...@ewilts.org Linkedin http://www.linkedin.com/in/ewilts ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2?
Keep hold of them, you never know :-) -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Lightner, Jeff Sent: Friday, March 19, 2010 8:08 PM To: Justin Piszcz Cc: Ed Wilts; veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2? Nah - quietly gathering dust at home along with the old 486 that I used it on. I'm thinking someday they'll be valuable as antiques. -Original Message- From: Justin Piszcz [mailto:jpis...@lucidpixels.com] Sent: Friday, March 19, 2010 4:01 PM To: Lightner, Jeff Cc: Ed Wilts; veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2? LOL :) Still in use? On Fri, 19 Mar 2010, Lightner, Jeff wrote: I'm starting to think my DC6525 may have no value any longer. :-) -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Justin Piszcz Sent: Friday, March 19, 2010 3:53 PM To: Ed Wilts Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2? On Fri, 19 Mar 2010, Ed Wilts wrote: On Fri, Mar 19, 2010 at 2:04 PM, Justin Piszcz jpis...@lucidpixels.comwrote: While this is cool, I am still waiting for the announcement and pricing on the IBM/Fujitsu(?) 35TB/tape technology. Unless you never plan on taking your tapes out of the library or have some VERY fast hardware, 35TB/tape doesn't do much except send a lot of empty tape off-site. 35TB is 35,000,000 MB. At 100MB/sec, that 350,000 seconds or a bit over 97 hours. In other words, you'd be writing for 4 straight days averaging 100MB/sec to fill a tape. Assuming you only write to a tape during a 12-hour backup window, 7/8 of your tape will be unused. I'm personally waiting for an environment here where I can sustain writing to all of my tape drives at 100MB/sec. I can't drive all of my LTO-3 drives at full speed. Having drives that demand a lot more than that just contributes to a lot more stop/start. Hi, I currently have the 100MiB/s++ (see 500-600MiB/s peaks) already with 10GbE and multiple LTO-3 drives connected for several years now. I am definitely looking towards the 35TB tapes, I wonder how fast you will be able to push data to them and what their cost will be. For smaller environments, they regularly achieve 100MiB/s (LTO-4) with single gigabit nics without any issue. What speeds do you see? Justin. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu 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. -- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu 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