Backup Log is not allowed while the recovery model is SIMPLE

Guide til Microsoft SQL Server 7.0 / 2000 / 2005

Hvis du for denne melddelse: "[Microsoft][ODBC SQL Server Driver][SQL Server]The statement BACKUP LOG is not allowed while the recovery model is SIMPLE" skal du ænde "Recovery model" til FULL.

Hvis du bruger MSDE, brug følgende kommando:
osql -E -S [Server Name] -Q "ALTER DATABASE [Database Name] SET RECOVERY FULL"

Dette vil aktivere transaksjonslogging for MSDE databaser, og tillate inkrementell / differensiell backup at køre uden problemer.

Backup log is not allowed while the recovery model is SIMPLE