Hot Backups for Databases
A user asked whether an Informix database can be backed up hot (online) with integrity, or whether the engine must be shut down first. Replies confirmed hot backups are a standard RDBMS feature: for Informix, ontape gives a point-in-time online backup, and Enterprise Replication or Veritas NetBackup's Informix agent are options; filesystem snapshots (NetApp, Veritas, Sun) were also suggested. Other posters covered MSSQL/Sybase DUMP DATABASE and Oracle. One warned that plain file-level copies while the engine is running are worthless. No single definitive answer was marked, but the consensus was yes, hot backups are supported.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi Quick question - Do the standard Database backup tools allow hot backups (ie ensuring data integrity). Or is the only way to guarantee any Database back via stopping the database (cold) & then backing it up. I assume there must be Hot Backup extensions supplied with the expensive storage management tools Any other ideas ??? Mike PS I have an Informix DB byfleetM@Hotmail.Com
> Do the standard Database backup tools allow hot backups (ie ensuring Definitely yes - at least for MSSQL, Sybase and (not 100% sure) Oracle. For former ones - just use DUMP DATABASE statement. Max
On file systems that have snapshot feature, you can shut down the database; take FS snapshot; then restart the databse. The data in snapshot is safe for backup. NetApp, Veritas, and Sun can do this. Supak "Maxim S. Shatskih" <maxim@storagecraft.com> writes: >> Do the standard Database backup tools allow hot backups (ie ensuring >Definitely yes - at least for MSSQL, Sybase and (not 100% sure) Oracle. >For former ones - just use DUMP DATABASE statement. > Max -- -- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >> Supak Lailert -- spk@yipintsoi.com >> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Ontape will backup a system as of a point in time. The hot site will have to be configured like the original system. A better way is to use Informix's Enterprise Replication if you want a "hot site" backup. Harry Johnson Keene Information Systems, Inc. In article <01bf76c7$e5608260$54e9868b@ws021341>, "byfleetM" <byfleetM@Hotmail.Com> wrote: > > Hi > > Quick question - > Do the standard Database backup tools allow hot backups (ie ensuring data > integrity). > Or is the only way to guarantee any Database back via stopping the database > (cold) & then backing it up. > > I assume there must be Hot Backup extensions supplied with the expensive > storage management tools > > Any other ideas ??? > > Mike > PS I have an Informix DB > > byfleetM@Hotmail.Com > Sent via Deja.com http://www.deja.com/ Before you buy.
We have installed Veritas Netbackup with the Netbackup extension for Informix. You have to check if your version of OS and version of Informix is supported ( http://www.veritas.com ). byfleetM wrote: > Hi > > Quick question - > Do the standard Database backup tools allow hot backups (ie ensuring data > integrity). > Or is the only way to guarantee any Database back via stopping the database > (cold) & then backing it up. > > I assume there must be Hot Backup extensions supplied with the expensive > storage management tools > > Any other ideas ??? > > Mike > PS I have an Informix DB > > byfleetM@Hotmail.Com
On Mon, 14 Feb 2000 12:39:30 +0300, "Maxim S. Shatskih" <maxim@storagecraft.com> wrote: >> Do the standard Database backup tools allow hot backups (ie ensuring > >Definitely yes - at least for MSSQL, Sybase and (not 100% sure) Oracle. >For former ones - just use DUMP DATABASE statement. > > Max > > oracle has it native. And, of course there are 3rd party vendors out there which can hot-backup just about any RDBMS you can think of. Copyright (c) 1999 David A. Lethe. Posting this material on the World Wide Web under CNET's Help.com service implies agreeing to a consultancy fee of US $150.00 - per posting. Violations are subject to civil prosecution for Copyright Infringement as applicable in the state, country, or territory they reside. Please direct your initial requests by email. (elethe@gte.net)
Mike; You can run hot backups in Access and in SQL server via replication. Barry byfleetM <byfleetM@Hotmail.Com> wrote in message news:01bf76c7$e5608260$54e9868b@ws021341... > > Hi > > Quick question - > Do the standard Database backup tools allow hot backups (ie ensuring data > integrity). > Or is the only way to guarantee any Database back via stopping the database > (cold) & then backing it up. > > I assume there must be Hot Backup extensions supplied with the expensive > storage management tools > > Any other ideas ??? > > Mike > PS I have an Informix DB > > byfleetM@Hotmail.Com >
> You can run hot backups in Access and in SQL server via replication. For SQL Server, this is a bit a perverted way :-) Replicate requires non-trivial setup - and DUMP DATABASE command is trivial. It provides a hot backup (a database snapshot at the moment of backup). Max
Mike, The short answer is: YES Doug "barry" <barry@jmesourcing.com> wrote in message news:9sdz4.1391$U3.51323@news.pacbell.net... > Mike; > > You can run hot backups in Access and in SQL server via replication. > > Barry > byfleetM <byfleetM@Hotmail.Com> wrote in message > news:01bf76c7$e5608260$54e9868b@ws021341... > > > > Hi > > > > Quick question - > > Do the standard Database backup tools allow hot backups (ie ensuring data > > integrity). > > Or is the only way to guarantee any Database back via stopping the > database > > (cold) & then backing it up. > > > > I assume there must be Hot Backup extensions supplied with the expensive > > storage management tools > > > > Any other ideas ??? > > > > Mike > > PS I have an Informix DB > > > > byfleetM@Hotmail.Com > > > >
"Maxim S. Shatskih" <maxim@storagecraft.com> writes: > For SQL Server, this is a bit a perverted way :-) > Replicate requires non-trivial setup - and DUMP DATABASE command is > trivial. It provides a hot backup (a database snapshot at the moment of > backup). I was wondering how long this thread was going to go on before someone pointed out that hot backups are a standard feature in most database products. The usual scheme is to dump the data and then the transaction log, which gives you a consistent backup. -- g
If you are using Windows NT, you can use UltraBac. www.ultrabac.com. Their product will backup any open databse or file. Jamey On Fri, 18 Feb 2000 04:58:00 GMT, david@santools.com (david a. lethe) wrote: >On Mon, 14 Feb 2000 12:39:30 +0300, "Maxim S. Shatskih" ><maxim@storagecraft.com> wrote: > >>> Do the standard Database backup tools allow hot backups (ie ensuring >> >>Definitely yes - at least for MSSQL, Sybase and (not 100% sure) Oracle. >>For former ones - just use DUMP DATABASE statement. >> >> Max >> >> >oracle has it native. And, of course there are 3rd party vendors out >there which can hot-backup just about any RDBMS you can think of. >Copyright (c) 1999 David A. Lethe. Posting this material on the World Wide Web >under CNET's Help.com service implies agreeing to a consultancy fee of >US $150.00 - per posting. Violations are subject to civil >prosecution for Copyright Infringement as applicable in the state, country, >or territory they reside. Please direct your initial requests by email. >(elethe@gte.net)
doing a file backup while the engine is up is like using device /dev/null. So, don't do that. Nona >Subject: Re: Hot Backups for Databases >From: jkirby@nospam.storagecraft.com (Jamey Kirby) >Date: 16.03.00 18:16 W. Europe Standard Time >Message-id: <38d116b3.137936291@news.tfb.com> > > >If you are using Windows NT, you can use UltraBac. www.ultrabac.com. >Their product will backup any open databse or file. > >Jamey > >On Fri, 18 Feb 2000 04:58:00 GMT, david@santools.com (david a. lethe) >wrote: > >>On Mon, 14 Feb 2000 12:39:30 +0300, "Maxim S. Shatskih" >><maxim@storagecraft.com> wrote: >> >>>> Do the standard Database backup tools allow hot backups (ie ensuring >>> >>>Definitely yes - at least for MSSQL, Sybase and (not 100% sure) Oracle. >>>For former ones - just use DUMP DATABASE statement. >>> >>> Max >>> >>> >>oracle has it native. And, of course there are 3rd party vendors out >>there which can hot-backup just about any RDBMS you can think of. >>Copyright (c) 1999 David A. Lethe. Posting this material on the World Wide >Web >>under CNET's Help.com service implies agreeing to a consultancy fee of >>US $150.00 - per posting. Violations are subject to civil >>prosecution for Copyright Infringement as applicable in the state, country, >>or territory they reside. Please direct your initial requests by email. >>(elethe@gte.net) >
>Subject: Re: Hot Backups for Databases >From: "Maxim S. Shatskih" maxim@storagecraft.com >Date: 14.03.00 18:21 W. Europe Standard Time >Message-id: <8amo1b$18bk$1@gavrilo.mtu.ru> > >> You can run hot backups in Access and in SQL server via replication. > >For SQL Server, this is a bit a perverted way :-) >Replicate requires non-trivial setup - and DUMP DATABASE command is >trivial. It provides a hot backup (a database snapshot at the moment of >backup). > > Max > > Informix has been doing that before there was any such thing called "SQL Server" from Microsurf. Nona