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 > Production Server to Test Server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-22-06, 22:42
chemaster chemaster is offline
Registered User
 
Join Date: Feb 2006
Posts: 13
Production Server to Test Server

What is the best (easiest) solution for backing up a DB on a production server and restoring it to a test server?

- Windows 2000 Server (both)
- DB2 UDB 8.1 (both)
- Test server has a fresh install of DB2

I have done this before by:
- exporting each table with ixf format
- making a blank DB with same name etc. on test server and importing
- the above worked but it was somewhat time consuming (1.6gb db)

I have attempted the following without success:
- making a db on the test server with same name, path and permissions
- making a blank backup of the production db with the same path as production db (c:\db_backup\ .....)
- attempting to replace the almost blank backup on my test server with a copy of the backup from by production backup
- it attempted the restore but there was many errors in the process

There must be a easiler way.

Suggestions?

Thanks,

Steve

Last edited by chemaster; 02-22-06 at 22:55.
Reply With Quote
  #2 (permalink)  
Old 02-23-06, 02:36
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
test

if same disk space is available :
backup database and restore redirect would be the easiest
define tablespace container has to be specified for each container that exists on source database and has not an equivalent on target server
otherwise backup-restore...
have a look at infocenter and restore command..
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
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