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