Backup copy of design master (1 Viewer)

[CoddFish]

I have developed a replicable database. I have run into a situation where I need to make some scary changes to the design master that involves changing a particular relationship that will have a cascading effect on a number of database objects. As such, I would like to be able to make a copy of the design master that I could revert to in case my design changes create irreversible chaos.

The problem is that I’m not sure how to do this. When I save the design master in a different location, or in the same location with a different file name, the new file becomes a replica instead of a second design master.

Does anyone have a suggestion as to how I might handle this situation?

-CoddFish

 

[wizcow]

Codfish

This may not be the best way, but what I do is...
open windows explorer, copy the db then...
paste it into my archive folder.
I rename the db with a date extension so I can keep track.
eg. "MyDb 031904"

If your db is split make sure to copy the back end too.

HTH
Tom

 

[CoddFish]

Tom,
Does this work with a Design Master in a replicated database?

Thanks.

-CoddFish

Codfish

This may not be the best way, but what I do is...
open windows explorer, copy the db then...
paste it into my archive folder.
I rename the db with a date extension so I can keep track.
eg. "MyDb 031904"

If your db is split make sure to copy the back end too.

HTH
Tom

 

[wizcow]

Coddfish

I'm not too sure. But there is a way to find out.
Copy the master db and then open it to make sure it works.

There may be a problem with syncronizing though.
Normally when I have a trouble with a db I try to repair it by importing the problem componets form an archived db. I seldom start from scratch with a backup.

Tom

 

[Keith P]

You can use the recover design master function to make a replica the design master in the event of dm corruption/loss.
If you want to test your changes copy the DM to a development computer. Use the Recover DM function so it becomes a DM and can be updated.
In the event that your live DM is damaged, create a new replica from an existing full replica (can't do it from a partial replica) and use the Recover DM to make it your new DM.
Keith