SQL-BackTrack by Datatools opinions 
Author Message
 SQL-BackTrack by Datatools opinions

   Hi,

    Is anyone using SQL-BackTrack by Datatools for Sybase database
backups? If so I would appreciate any opinions on the product.
Specifics to our site are Sybase 10.0.2, Solaris 2.4, Sparcserver1000
with the sun4d kernel. Opinions of SQL-Backtrack need not be limited
to the beforementioned architecture though. Depending on response
will post a summary. Thanks!


                                        American Student Assistance



Sun, 14 Dec 1997 03:00:00 GMT
 SQL-BackTrack by Datatools opinions

Quote:

>   Hi,

>    Is anyone using SQL-BackTrack by Datatools for Sybase database
>backups? If so I would appreciate any opinions on the product.
>Specifics to our site are Sybase 10.0.2, Solaris 2.4, Sparcserver1000
>with the sun4d kernel. Opinions of SQL-Backtrack need not be limited
>to the beforementioned architecture though. Depending on response
>will post a summary. Thanks!


>                                    American Student Assistance

We are using SQL-BackTrack to backup Sybase 4.9.2 databases and sybase 10.0.1
databases. Each of these databases are on a different server. We have a single
backups server on which the server module of SQL BackTrack is loaded.
All our server are running Solaris 2.4 with a mix of SS20's SS5's and 1000 's.
It works fine and we are fairly happy with the product.  It can do a level 0
backup and incremental backups or a transaction log backup. It can compress
database backups so that writes to tape are reduced.
The backup scheme we are using is a weekly full backup ( level 0 ) and daily
level 1 backups. A level 1 backup is from the previous level 0 backup, which
means you need a level 0 and the last level 1 backup to restore.  Further
we are doing hourly transaction log backup to disk which is scheduled through
cron. We are not using SQL-Backtrack for this, though we could.
The SQL-Backtrack backups are scheduled through a product called Networker. The
two work well together.  The backups are totally automated.
Why we did not use SQL BackTrack for log backups was that Networker cannot
schedule hourly jobs.

Sql-BackTrack can do a object level recovery too, whcih means you could recover
only a single table if you wanted.

The only minus point about the product is that the recovery is slow. A direct
load database is much faster. One can afford to live with that since one can
afford time for recovery.

Hope this helps.

- pankaj



Mon, 15 Dec 1997 03:00:00 GMT
 SQL-BackTrack by Datatools opinions

|>    Is anyone using SQL-BackTrack by Datatools for Sybase database
|>backups? If so I would appreciate any opinions on the product.
|>Specifics to our site are Sybase 10.0.2, Solaris 2.4, Sparcserver1000
|>with the sun4d kernel. Opinions of SQL-Backtrack need not be limited
|>to the beforementioned architecture though. Depending on response
|>will post a summary. Thanks!

Certainly are, in very similar environments.
It performs well, with compression, will reduce 10Gb data (yes i mean data, not
Db size) to 2.1Gb on disk (we dump direct to disk) in ~ 2hrs. That's on a Sun 20/71
with 2 engines and RAID3 devices (sybase data & dump FS).

Next version will support stripping with 10. As it is, it keeps its files to 2Gb
chunks to avoid Unix limits.
Even a 'physical' dump will allow you to load an individual table back, 'logical'
dumps are very flexible.

---
  ---------------------------------------------------------------
  | David J Ferrington        The art of RDBMS's is a "Syance"! |
  | Swiss Bank Corp                                             |

  |--------------------------------------------------------------
  |                 Normal Disclaimers Apply :-)                |
  ---------------------------------------------------------------
-D



Mon, 15 Dec 1997 03:00:00 GMT
 SQL-BackTrack by Datatools opinions

Quote:
>The only minus point about the product is that the recovery is slow. A
direct
>load database is much faster. One can afford to live with that since one
can
>afford time for recovery.

only if you restore the whole db!!!
if you only need to restore a table due to disk failure (98% of time here)
it could increase restore speed drastically!


Wed, 18 Feb 1998 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Datatools SQL BackTrack

2. Interdev DataTools & SQL-DMO - HOW TO DO

3. CT-HARTFORD-113247--DBA Skills-ORACLE-UNIX-Banking Applications-SQL Backtrack-Database Administator

4. SQL Backtrack

5. SQL*Backtrack:Anyone Using It?

6. Sql BackTrack vs RMAN

7. What do U think of SQL Backtrack?

8. SQL*BackTrack please share your experience

9. Backup of the SQL-BackTrack catalog?

10. CT-HARTFORD-113247--DBA Skills-ORACLE-UNIX-Banking Applications-SQL Backtrack-Database Administator

11. 9i Newbie : spfile, sql-backtrack questions

12. How do I backup the SQL BackTrack catalog????


 
Powered by phpBB® Forum Software