Database Backup Options

[ducatiross]

Hi all,

We use a SQL Server database for our EA models. At the moment, our backup capability is fairly coarse - we simply have a nightly backup of the entire database. So if we need to recover anything, we can only recover the whole database as of the previous night.

Does anyone use anything else that allows more granular control over what is backed up and then restored ? Perhaps a transaction logging capability that would allow the restoration of all objects and diagrams created or modified by a certain user from a certain date ?

Any suggestions that work well with EA would be appreciated.

thanks

[Geert Bellekens]

A selective restore is not possible I think, but our DBA's have setup a system that allows restore points every 20 minutes or so.

I don't know how they do it however. All I know is that I can choose from a couple of restore points per hour if I need to restore a backup of the database. (I needed that twice in six years)

Geert

[Takeshi K]

In my experience, I use DBMS-offered backup feature. When I want to restore part of the model, I restore the backup data to another (temporary) DBMS database and export target backup as XMI, then import it to the original DBMS repository.

To do this operation easily, it is nice to set up another DBMS repository on other (virtual) machine in advance.

HTH,

[ducatiross]

Thanks Geert and T-Kuono, I will consider both those suggestions.

I like the sound of a backup every 20 minutes !