Re: BACKUP DB Question

2006-02-23 Thread Allen S. Rout
>> On Thu, 23 Feb 2006 10:48:06 -0500, Dave Zarnoch <[EMAIL PROTECTED]> said: > I calculated that our DB is @61GB > The manufacturer says the tape can hold 50GB compressed > What do you think is happening? Most tape vendors use 2.mumble for their expected compression ratio. Database backups ten

Re: BACKUP DB Question

2006-02-23 Thread Paul Zarnowski
At 10:48 AM 2/23/2006, Dave Zarnoch wrote: I calculated that our DB is @61GB The manufacturer says the tape can hold 50GB compressed What do you think is happening? Keep in mind that many databases have lots of zeroes in them (unused space within pages). In this situation, they can be compre

Re: BACKUP DB Question

2006-02-23 Thread Dave Zarnoch
ADSM-L@VM.MARIST.EDU Sent by: "ADSM: cc: Dist Stor Subject: Re: [ADSM-L] BACKUP DB Question Manager" <[EMAIL PROTECTED] .EDU> 02/2

Re: BACKUP DB Question

2006-02-23 Thread Richard Sims
On Feb 23, 2006, at 10:48 AM, Dave Zarnoch wrote: I calculated that our DB is @61GB The manufacturer says the tape can hold 50GB compressed What do you think is happening? Magic. Your posting did not specify which level of 9840 drive/cartridge technology is being used. I'll then assume 9840A

Re: BACKUP DB Question

2006-02-23 Thread Dave Zarnoch
TED]> To: ADSM-L@VM.MARIST.EDU Sent by: "ADSM: cc: Dist StorSubject: Re: [ADSM-L] BACKUP DB Question Manager" <[EMAIL PROTECTED]

Re: BACKUP DB Question

2006-02-23 Thread Richard Sims
On Feb 23, 2006, at 9:50 AM, Dave Zarnoch wrote: We have a TSM DB Backup that occurs every morning: ... 02/23/06 07:18:47 ANR4550I Full database backup (process 918) complete, 16707519 pages copied. (SESSION: 17232, PROCESS: 918) ... I'm a little bit leary that i

BACKUP DB Question

2006-02-23 Thread Dave Zarnoch
We have a TSM DB Backup that occurs every morning: Here are the results: 02/23/06 06:31:46 ANR2017I Administrator ADMIN issued command: BACKUP DB devclass=C_DEVC type=full wait=yes (SESSION: 17232) 02/23/06 06:34:46 ANR0984I Process 918 for DATABASE BACKUP

Re: BACKUP STGPOOL and BACKUP DB Question

2000-08-14 Thread Kelly J. Lipp
storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Werner Nussbaumer Sent: Monday, August 14, 2000 7:39 AM To: [EMAIL PROTECTED] Subject: Re: BACKUP STGPOOL and BACKUP DB Question Thank you also for your information. Kind regards We

Re: BACKUP STGPOOL and BACKUP DB Question

2000-08-14 Thread Werner Nussbaumer
Thank you also for your information. Kind regards Werner Nussbaumer -Original Message- From: payne [mailto:[EMAIL PROTECTED]] Sent: Freitag, 11. August 2000 17:28 To: ADSM-L Cc: payne Subject: Re: BACKUP STGPOOL and BACKUP DB Question We do: 1) Backup Disk 2) Backup Tape 3) Backup DB

Re: BACKUP STGPOOL and BACKUP DB Question

2000-08-14 Thread Werner Nussbaumer
Thank you very much for your information, I'll do it this way. Kind regards Werner Nussbaumer -Original Message- From: Phillip.Ford [mailto:[EMAIL PROTECTED]] Sent: Freitag, 11. August 2000 17:34 To: Phillip.Ford; ADSM-L Subject: Re: BACKUP STGPOOL and BACKUP DB Question I can no

Re: BACKUP STGPOOL and BACKUP DB Question

2000-08-11 Thread Kyle Payne
yle [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Werner Nussbaumer Sent: Friday, August 11, 2000 9:20 AM To: [EMAIL PROTECTED] Subject: BACKUP STGPOOL and BACKUP DB Question Hello All I set up a storage pool DISKPOOL, a tape poo

Re: BACKUP STGPOOL and BACKUP DB Question

2000-08-11 Thread Ford, Phillip
Nussbaumer [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 9:20 AM To: [EMAIL PROTECTED] Subject: BACKUP STGPOOL and BACKUP DB Question Hello All I set up a storage pool DISKPOOL, a tape pool DLTPOOL1 (4 tapes) and a copypool DLTPOOL2 (4 tapes). DISKPOOL is migrated to the next pool

BACKUP STGPOOL and BACKUP DB Question

2000-08-11 Thread Werner Nussbaumer
Hello All I set up a storage pool DISKPOOL, a tape pool DLTPOOL1 (4 tapes) and a copypool DLTPOOL2 (4 tapes). DISKPOOL is migrated to the next pool DLTPOOL1. After that I would do a BACKUP STGPOOL DISKPOOL1 DLTPOOL2 and BACKUP STGPOOL DLTPOOL1 DLTPOOL2 and finally BACKUP DB DEVCLASS=DLTCLAS