Unity MSDE/SQL database file corruption

[admin_2]

HI,

just wondering what happens if the Unity MSDE/SQL database files gets corrupted. For example, if the UnityDB and the ReportDB gets corrupt what would be the results.

Let's say those gets corrupt. Will Unity still start all of its sevices but subsribers won't be able to access your voicemail? My understaning is that the Unity configurations gets stored in one of those databases.

There was a incident at our company in which the UNityDB and ReportDB was used as the backup destination with the "append to media" selected to backup those databases. We were using the "backup database" feature in SQL ENterprise Manager. I think that would have corrupted the database.

Is this correct?

thanks in advance.

[uversave]

Hi

We use the UnityDB as our main store where we keep everything and some of it is replicated to AD. If this gets corrupted we are in a rather bad situation. We can expect all kind of strange behaviour. Also if SQL gets corrupted up to a point where it cannot startup anymore or it stops it will take with it Unity down as well as we are dependent on SQL.

For these reasons we always suggest customers to have in place a backup strategy with a third party approved backup software and in addition to that we can always have a backup made by the DIRT utility.

For more info on DIRT see http://www.ciscounitytools.com/App_DisasterRecoveryTools.htm

For more info on third party approved backup software see:

http://www.cisco.com/en/US/products/sw/voicesw/ps2237/prod_pre_installation_guide09186a0080117617.html#88410

Ullie

[uversave]

Hi

In addition the Unity database file is called UnityDb.mdf and the backup are normally eg Unitydb.bak files so it is very unlikely you have corrupted the database that way.

Also the append to media means the following:

The previous contents of the media remain intact, and the new backup is written after the end of the last backup on the media

Kind Regards

Ullie