Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    13

    Unanswered: 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 23:55.

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •