A user deleted a business contact (a lead, not at active contact) and asked
IT to restore it. We went to the server, pulled the .mdf and .ldf files, and
restored them to a local database. The lead was not there.

We then took a BCM export file .bcm and restored it. The lead was there.

Why?

The SQL backups are automatic, the BCM export is not. Shouldn't the SQL
files include ALL of the data? I want to make sure that we have a reliable
backup of the data. Advice or explaination anyone?

Please, notice that in BCM you have a folder "Deleted elements" (this is a
translation into English, so the name might be different...) - until it is
flushed all deleted elements of BCM are there.
--
Maciek


"joesmith" wrote:

> A user deleted a business contact (a lead, not at active contact) and asked
> IT to restore it. We went to the server, pulled the .mdf and .ldf files, and
> restored them to a local database. The lead was not there.
>
> We then took a BCM export file .bcm and restored it. The lead was there.
>
> Why?
>
> The SQL backups are automatic, the BCM export is not. Shouldn't the SQL
> files include ALL of the data? I want to make sure that we have a reliable
> backup of the data. Advice or explaination anyone?

On Apr 10, 1:32*am, Jantar2B <Janta...@discussions.microsoft.com>
wrote:
> Please, notice that in BCM you have a folder "Deleted elements" (this is a
> translation into English, so the name might be different...) - until it is
> flushed all deleted elements of BCM are there.
> --
> Maciek
>
>
>
> "joesmith" wrote:
> > A user deleted a business contact (a lead, not at active contact) and asked
> > IT to restore it. *We went to the server, pulled the .mdf and .ldf files, and
> > restored them to a local database. *The lead was not there.
>
> > We then took a BCM export file .bcm and restored it. *The lead was there.
>
> > Why?
>
> > The SQL backups are automatic, the BCM export is not. *Shouldn't the SQL
> > files include ALL of the data? *I want to make sure that we have a reliable
> > backup of the data. *Advice or explaination anyone?- Hide quoted text -
>
> - Show quoted text -

Generally, if you delete an item, it moves to the Deleted Items folder
and can be restored by dragging it back to the Business Contacts
folder.

Export doesn't export deleted items.

A database backup should be a perfect snapshot of the database, and
include every record, marked as deleted or not.

I think the difference, why the contact was in one and not the other,
is probably due to the time when each was the files were created.

Note that the .MDF file is the actual database file, and not a sql
backup.