Native database backup, can you backup keys

themave

The restore process is so slow because the system has to create all the keys to complete the process. I would rather have a larger backup file and faster restore (recovery) then the current, which is a smaller backup file, but slow restore.

I know all about hotcopy, but I am interested if anybody knows how to modify the native database backup to include the keys two. I guess the restore routine would also have to be modified to know the keys are there.

any ideas ?

Savatage

For us, I just added a 80gb hard drive - mapped it and at the end of the day when everyone is out just copy the entire file from the server to that drive using a batch file.

quick copy & quick restore. hopefully never necessary but the restore takes as long as a 17gb file can be transfered from 1 drive to the other.

works for us.

copy n:\database.fdb z:\backup\database.fdb

obviously this method does not work if people are still logged into the database but this is not a problem for us.

Waldo

I recommend to add the "net stop" and "net start" to the bat-file, just to be sure to back up a consistent copy of your fdb.

HOTCOPY works well too (when you don't want to stop the database server). basically, it's just copy-ing a database server when it's still online. You have the option to do a daily test as well wity HOTCOPY.