With the SQL Database set to SIMPLE you can't run a backup of the redologs
(transactionlogs), but only full backups.
If your SQL-dba wants to have log backups he should set the DB recovery mode
to full in the SQL-Enterprise Manager.

(we never backup the Northwind-DB)

Jeroen

-----Original Message-----
From: Robert Ouzen [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
Sent: woensdag 6 augustus 2003 10:33
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Rc=1914 on TDP for Microsoft Sql backup .... More


Hi to all

Check my TDP log and got this:

08/05/2003 03:33:53 Backup of Northwind failed.
08/05/2003 03:33:53 ACO5422E Received the following from the MS SQL server:
08/05/2003 03:33:53 [Microsoft][ODBC SQL Server Driver][SQL Server]The
statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use
BACKUP DATABASE or change the recovery model using ALTER DATABASE.

What is the meaning !!!!!! And what I have to do .....

T.I.A  Regards

Robert Ouzen
Helpdesk Manager
Haifa University
Israel
e-mail:rouzen AT univ.haifa.ac DOT il