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:[EMAIL PROTECTED] Sent: woensdag 6 augustus 2003 10:33 To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]
