In general, it is more often that a backup of the current production database is taken and a copy of the same database in a development or testing environment is refreshed from this backup. The database to be refreshed needs to be the same size as the source database with data and log segments created preferably in the image of the source database (otherwise data and log segments could mix upon refresh).
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
The source database is backed up using Sybase's backup server into the operating system file(s). These files are binary. The most common method is to transfer these files to the host server containing the recipient Sybase server and database. Again the Sybase's backup server is used to load the database.
Dig Deeper on Open source databases
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.