Ask the Expert

Back up data to the test partition

We are currently going from a 640 to a partitioned 730. The 730 is a basic setup with a test and production partition. We are looking for a way to copy data from our production partition to our test partition and then run all of our backups in the test partition to increase our availability. Is there a way to copy or back up data to our test partition from the production partition without using expensive replicating software?

There are a number of ways to do this; however, all of them require some programming. You can do copy to DDM files that point to the development partition or use triggers to copy records as they are used, creating an image of your data as it is used on the development partition. In some instances, the save using the SAVACT parameter will allow data to be saved while allowing user access. In most cases, only a small set of files are updated constantly. Using a combination of copying static files when they change and triggers for dynamic data usually does the trick.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Ask the Experts yourself: Our Backup & Recovery gurus are waiting to answer your questions.

Search400.com's targeted search engine: Get relevant information on backup & recovery.

Check out this Search400.com Featured Topic on backup & recovery.


This was first published in February 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: