onbar - restoring old dbspaces into a current system 
Author Message
 onbar - restoring old dbspaces into a current system

An application we have has progressed from c-isam files to an Online
instance. In the past there have been times when a set of files ( now
grouped into dbspaces ) had to be restored from previous years so that aged
reports could be run. This was relatively easy using the filesystem, but
does not seem that simple with Online.

With other instances I rely on ontape for the backups but think that onbar
may give the flexibility to carry out the above task, BUT ...

With onbar will I be able to restore a dbspace of several months previous
from a level 0 archive, into an instance where other dbspaces are at the
current date? Transaction logging is turned on for all databases so will I
have problems with the logical logs?

Thanks in advance for any suggestions.

Graham Bartlett
If Emailing remove the X



Mon, 21 May 2001 03:00:00 GMT
 onbar - restoring old dbspaces into a current system

Onbar will allow point in time recovery (which is probably what you need),
but only for the whole instance not a single dbspace.
You'd have to restore everything to the old point in time, run your reports,
then restore everything back up to current time.
Sorry, this would be a nice feature though!


Tue, 22 May 2001 03:00:00 GMT
 onbar - restoring old dbspaces into a current system
Thanks for your input Steve.
At the moment it would seem that the only solution would be to have a
separate instance for each database on a single server and try and work out
how to back up each instance unattended ! My headache is getting worse !



Quote:
> Onbar will allow point in time recovery (which is probably what you
need),
> but only for the whole instance not a single dbspace.
> You'd have to restore everything to the old point in time, run your
reports,
> then restore everything back up to current time.
> Sorry, this would be a nice feature though!



Tue, 22 May 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Fw: onbar dbspace level restore problem ...

2. onbar dbspace level restore problem ...

3. Fw: onbar dbspace level restore problem ...

4. onbar dbspace restore problem

5. Restore from old backup and current transaction log

6. Difference between the old devices and the current storage system in sql server 2000

7. Using Onbar to do a system restore

8. Single Database Restore / Single DBSPACE RESTORE

9. Onbar Restore Error - Can't Restore Reserved Pages

10. OLD YES VERY OLD SYSTEM - HELP PLEASE

11. logging into and changing current dbspaces

12. Can I see search the current or old bugs


 
Powered by phpBB® Forum Software