**** PLEASE DON'T POST HTML ****

The 2 Gb limit is an IDS limit (in IDS7 and IDS9 below 9.4).
You will only be able to set tape size to 2097152 (2Gb) and
will get prompted for a new tape every time this size is reached.
By setting the TAPEDEV to a soft link you can change the link
to point to a different file for each subsequent 'tape'.
I assume the disk system you are archiving to is on a totally
separate controller to where the database is.
Have you thought about restores? You will need to go through a
similar mechanism of swapping softlinks from file to file in
order to restore.
Where are you backing up your log files? How will you roll them
forward in the event of a restore?
Why do you feel back-up to disk is any 'better' than tape?

Keith

-----Original Message-----
From: ORourke, Scott [mailto:ScottORourke@liberata.com]
Sent: Friday, May 13, 2005 11:08 AM
To: 'Dirk Moolman'; informix-list@iiug.org
Subject: RE: Backup to disk, then tape


PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT OPEN ANY ATTACHMENT WITHOUT PRIOR VIRUS CHECKING.
__________________________________________________ ________________


Make sure you don't hit the filesystem and/or IDS file size limit!
I hit this on 7.31 on SCO Openserver 5.05, where, if I remember correctly, think it was 2gig.
Can't remember if this was a SCO or IDS limit though.
You can however get round this by setting TAPESIZE appropriately, along with some clever scripting.
-----Original Message-----
From: Dirk Moolman [mailtoirkM@mxgroup.co.za]
Sent: 13/May/2005 10:38
To: informix-list@iiug.org
Subject: Backup to disk, then tape


I have to do some backup testing this weekend, testing a new way of
backing up our systems.
I want to backup to disk, and then back the disk up to tape - which I
haven't done before.
Any tips / tricks you can share with me ?



IDS 7.31 FD3
Solaris 9





Dirk Moolman
Database and Unix Administrator
HEALTHCORP



"People demand freedom of speech as a compensation for the freedom of
thought which they seldom use."


sending to informix-list


__________________________________________________ ________________
Liberata is the trading name of Liberata UK Limited (Registered in England and Wales - No 1238274) and other Liberata group companies which include Liberata Financial Services Limited (Registered in England and Wales - No 5301492), an entity authorised and regulated by the Financial Services Authority. The holding company is Liberata plc ( Registered in England and Wales - No 3987802).

Registered Offices, 17 London End, Beaconsfield Old Town, Buckinghamshire, HP9 2HN

IMPORTANT NOTICE:
This e-mail (including all attachments) is confidential and may be privileged. It is for the exclusive use of the intended recipient(s) only, and must not be re-transmitted in an amended form without our consent. If you have received it in error, please contact us immediately at ITSecurity@liberata.com. Please then delete it and do not disclose its contents to any other person.

Security and reliability of e-mails are not guaranteed. We operate anti-virus programmes but you must take full responsibility for virus checking this e-mail (including all attachments). Liberata plc do not accept any liability in respect of any damage caused by any virus which is not detected.

All e-mails to and from anyone @liberata.com may be examined for breaches of employee policies and the law. All e-mails to anyone @liberata.com are communications to the company and not private and confidential to any named individual.

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************


sending to informix-list

"Simmons, Keith" <keith.simmons@office2office.biz> wrote in message
news:1115990941.b78ec499a3866b68ff6d30877efb4876@t eranews...
>
> **** PLEASE DON'T POST HTML ****
>
> The 2 Gb limit is an IDS limit (in IDS7 and IDS9 below 9.4).
> You will only be able to set tape size to 2097152 (2Gb) and
> will get prompted for a new tape every time this size is reached.
Don't believe this is correct. If there IS a limit it's an *IX limit - and
while I know so little about that OS you could write it on an ant's bollocks
in block capitals and still have space left, as I understand it - this would
not be an issue writing to raw.
Certainly on Win 2000 - I've been writing backups of up to 200Gb to disc and
having them backed up to tape via Legato later using 9.21, and we've done
loads of DR tests and the restore has worked fine

> By setting the TAPEDEV to a soft link you can change the link
> to point to a different file for each subsequent 'tape'.
> I assume the disk system you are archiving to is on a totally
> separate controller to where the database is.
> Have you thought about restores? You will need to go through a
> similar mechanism of swapping softlinks from file to file in
> order to restore.
> Where are you backing up your log files? How will you roll them
> forward in the event of a restore?
> Why do you feel back-up to disk is any 'better' than tape?
Because if you have the room it's faster, and therefore reduces your
exposure in (certain) disaster situations?
If you write to a different disc array, and your discs holding your chunks
clatter - once you've replaced them, your restore is a lot faster

>
> Keith
>
> -----Original Message-----
> From: ORourke, Scott [mailto:ScottORourke@liberata.com]
> Sent: Friday, May 13, 2005 11:08 AM
> To: 'Dirk Moolman'; informix-list@iiug.org
> Subject: RE: Backup to disk, then tape
>
>
> PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT OPEN ANY ATTACHMENT WITHOUT
PRIOR VIRUS CHECKING.
> __________________________________________________ ________________
>
>
> Make sure you don't hit the filesystem and/or IDS file size limit!
> I hit this on 7.31 on SCO Openserver 5.05, where, if I remember correctly,
think it was 2gig.
> Can't remember if this was a SCO or IDS limit though.
> You can however get round this by setting TAPESIZE appropriately, along
with some clever scripting.
> -----Original Message-----
> From: Dirk Moolman [mailtoirkM@mxgroup.co.za]
> Sent: 13/May/2005 10:38
> To: informix-list@iiug.org
> Subject: Backup to disk, then tape
>
>
> I have to do some backup testing this weekend, testing a new way of
> backing up our systems.
> I want to backup to disk, and then back the disk up to tape - which I
> haven't done before.
> Any tips / tricks you can share with me ?
>
>
>
> IDS 7.31 FD3
> Solaris 9
>
>
>
>
>
> Dirk Moolman
> Database and Unix Administrator
> HEALTHCORP
>
>
>
> "People demand freedom of speech as a compensation for the freedom of
> thought which they seldom use."
>
>
> sending to informix-list
>
>
> __________________________________________________ ________________
> Liberata is the trading name of Liberata UK Limited (Registered in England
and Wales - No 1238274) and other Liberata group companies which include
Liberata Financial Services Limited (Registered in England and Wales - No
5301492), an entity authorised and regulated by the Financial Services
Authority. The holding company is Liberata plc ( Registered in England and
Wales - No 3987802).
>
> Registered Offices, 17 London End, Beaconsfield Old Town, Buckinghamshire,
HP9 2HN
>
> IMPORTANT NOTICE:
> This e-mail (including all attachments) is confidential and may be
privileged. It is for the exclusive use of the intended recipient(s) only,
and must not be re-transmitted in an amended form without our consent. If
you have received it in error, please contact us immediately at
ITSecurity@liberata.com. Please then delete it and do not disclose its
contents to any other person.
>
> Security and reliability of e-mails are not guaranteed. We operate
anti-virus programmes but you must take full responsibility for virus
checking this e-mail (including all attachments). Liberata plc do not accept
any liability in respect of any damage caused by any virus which is not
detected.
>
> All e-mails to and from anyone @liberata.com may be examined for breaches
of employee policies and the law. All e-mails to anyone @liberata.com are
communications to the company and not private and confidential to any named
individual.
>
>
************************************************** **************************
******
> This message is sent in strict confidence for the addressee only. It may
> contain legally privileged information. The contents are not to be
disclosed
> to anyone other than the addressee. Unauthorised recipients are requested
> to preserve this confidentiality and to advise the sender immediately of
any
> error in transmission.
> This footnote also confirms that this email message has been swept for the
> presence of computer viruses, however we cannot guarantee that this
message
> is free from such problems.
>
************************************************** **************************
******
>
>
> sending to informix-list