If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > partial restore of server-backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-18-03, 07:07
blom0344 blom0344 is offline
Registered User
 
Join Date: Jan 2003
Location: Zutphen,Netherlands
Posts: 256
partial restore of server-backup

For financial reasons we want to restore part of the full-server backup of a DB2 server , namely the database file of one of the databases.

If we would restore this into a different folder could we somehow get to the data of that moment.

Or should we create a backup of the database now. Restore the partial backup of the server into the current folder , acces the data through the database and later on restore the backup we made today.

I am clinging at straws here, but perhaps someone has encountered this type of problem before.........
__________________
Ties Blom
Senior Application Developer BI
Getronics Healthcare
DB2,ORACLE,Powercenter,BusObj,Access,
SQL, SQL server
Reply With Quote
  #2 (permalink)  
Old 12-18-03, 15:15
GertK GertK is offline
Registered User
 
Join Date: Nov 2003
Location: Netherlands
Posts: 96
Re: partial restore of server-backup

Quote:
Originally posted by blom0344
For financial reasons we want to restore part of the full-server backup of a DB2 server , namely the database file of one of the databases.

If we would restore this into a different folder could we somehow get to the data of that moment.

Or should we create a backup of the database now. Restore the partial backup of the server into the current folder , acces the data through the database and later on restore the backup we made today.

I am clinging at straws here, but perhaps someone has encountered this type of problem before.........
It the OS backup was created when the database wasn't active restoring the files might work. You need the db2relocatedb command to be able to use it.

Regards, Gert
Reply With Quote
  #3 (permalink)  
Old 12-19-03, 03:51
blom0344 blom0344 is offline
Registered User
 
Join Date: Jan 2003
Location: Zutphen,Netherlands
Posts: 256
Thanks Gert,

As it turned out we appeared to have a backup of the database all the same,so I could restore the database backup file into another database and get at the data............
__________________
Ties Blom
Senior Application Developer BI
Getronics Healthcare
DB2,ORACLE,Powercenter,BusObj,Access,
SQL, SQL server
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On