>Hi,
>And the recovery model is...?
>
>Valentin

The Recovery Model the method/type/format (can't think of the correct term) SQL Server uses when writing to the database and transaction log.

To see the Recovery Model for a SQL Database, from Enterprise Manager select Properties of a database. Then selection Options.

Simple
Simple Permits high-performance bulk copy operations.
Reclaims log space to keep space requirements small.
Changes since the most recent database or differential backup must be redone. Can recover to the end of any backup. Then changes must be redone.

Full
Full No work is lost due to a lost or damaged data file. Can recover to an arbitrary point in time (for example, prior to application or user error).
Normally none. If the log is damaged, changes since the most recent log backup must be redone.
Can recover to any point in time.

Bulk-Logged
Bulk-Logged Permits high-performance bulk copy operations. Minimal log space is used by bulk operations.
If the log is damaged, or bulk operations occurred since the most recent log backup, changes since that last backup must be redone. Otherwise, no work is lost.
Can recover to the end of any backup. Then changes must be redone.