how to perform the 100 GB capacity database backups???
Posted in 2005
Topics: General Discussion
This is a multipart mime message --Next_1112945434---0-202.54.124.152-15284 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All,=0Ai have a small doubut that currently we are using the databases w= hich is 20 to 30GB capacity.But we are expecting that it will reach 100 to = 120GB..So in this case how i can perform the back up's without end users op= erations.Normally how long it will take?.Is there any way to reduce the bac= kup time?.=0A=0AMuralidhar=0A --Next_1112945434---0-202.54.124.152-15284 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline <P>=0AHi All,<BR>=0Ai have a small doubut that currently we are using the d= atabases which is 20 to 30GB capacity.But we are expecting that it will rea= ch 100 to 120GB..So in this case how i can perform the back up's without en= d users operations.Normally how long it will take?.Is there any way to redu= ce the backup time?.<BR>=0A<BR>=0AMuralidhar<BR>=0A=0A</P>=0A<br><br>=0A<A = target=3D"_blank" HREF=3D"http://clients.rediff.com/signature/track_sig.asp= "><IMG SRC=3D"http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.redif= fmail.com/inbox.htm@Bottom" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A --Next_1112945434---0-202.54.124.152-15284-- sending to informix-list
Siddabathuni Muralidhar wrote:
> This is a multipart mime message
PLEASE DO NOT POST MIME!!!! It wastes bandwidth and is VERY difficult to read
for the majority of us here who do not use a browser to read news posts.
> Hi All,=0Ai have a small doubut that currently we are using the databases w=
> hich is 20 to 30GB capacity.But we are expecting that it will reach 100 to =
> 120GB..So in this case how i can perform the back up's without end users op=
> erations.Normally how long it will take?.Is there any way to reduce the bac=
> kup time?.=0A=0AMuralidhar=0A
You would get a third party archive solution like Legato Networker (or
others) that support the XBSA archiving interface that Informix adheres to.
Most of these are capable of reading multiple parallel input streams from
the IDS server and of writing to multiple storage devices on the backside.
IDS supports this through the onbar archive tool but not with ontape. BTW,
you do not have to make your archives during off times when users are not
online. IDS was designed around making consistent archives while fully
online and in active use. There is some impact on user performance and on
the archive times but it's relatively minor.
Art S. Kagel