Re: backup and restore one db in dbspace

Kiran Manur wrote: > hi, > I have multiple databases in one dbspace, I need to change one of the > databases from buffered loging to no logging. I just want to know if I > can backup only one database from the dbspace and also restore the same > > Also I need to know If load and unload command uses logging. I feel > load does logging and unload doesn't(I might be wrong)??Can anyone > confirm... > > Thanks in advance > Kiran Kiran, To change the database from buffrered logging to no logging, can be done without backup and restore. ver 5.x - Change the TAPEDEV parameter in your configuration file to /dev/null - Execute tbtape -s -N your_database_name. It should be the same for ver 7.x. Just change tbtape to ontape. But if you do need to backup and restore a database , you could use dbexport/dbimport (exclusive lock on the database needed) or write your own unload/load shell scripts to do the same. Yes, if your database has logging turned on, then the loads will be logged. Hope this helps. -- Rajiv Jhaveri (rajivp@qsun.ho.att.com)