Sql log backup error
2004-10-17 02:22:34
Hi to all
Till now I backup the sql log successfully but from yesterday got this error
message:
10/16/2004 10:30:04 Request : LOG BACKUP
10/16/2004 10:30:04 Database Input List : *
10/16/2004 10:30:04 Group Input List : -
10/16/2004 10:30:04 File Input List : -
10/16/2004 10:30:04 Number of Buffers : 3
10/16/2004 10:30:04 Buffer Size : 1024
10/16/2004 10:30:04 Number of SQL Buffers : 0
10/16/2004 10:30:04 SQL Buffer Size : 1024
10/16/2004 10:30:04 Number of Stripes specified : 1
10/16/2004 10:30:04 Estimate : 0
10/16/2004 10:30:04 Truncate Log? : Yes
10/16/2004 10:30:04 Wait for Tape Mounts? : Yes
10/16/2004 10:30:04 TSM Options File :
C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt
10/16/2004 10:30:04 TSM Nodename Override : -
10/16/2004 10:30:05 Sqlserver : HIGHLEARN
10/16/2004 10:30:05
10/16/2004 10:30:07 Backup of Campus failed.
10/16/2004 10:30:07 ACO5422E Received the following from the MS SQL server:
10/16/2004 10:30:07 [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.
10/16/2004 10:30:07 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG
is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000)
(HRESULT:0x80041070)
10/16/2004 10:30:11 Total SQL backups selected: 7
10/16/2004 10:30:11 Total SQL backups attempted: 3
10/16/2004 10:30:11 Total SQL backups completed: 2
10/16/2004 10:30:11 Total SQL backups excluded: 4
10/16/2004 10:30:11 Throughput rate: 66.21 Kb/Sec
10/16/2004 10:30:11 Total bytes transferred: 304,672
10/16/2004 10:30:11 Elapsed processing time: 4.49 Secs
10/16/2004 10:30:11 ACO0151E Errors occurred while processing the request.
My TDPsql version is 5.1.5.0 .
T.I.A Regards
Ouzen Robert
rouzen AT univ.haifa.ac DOT il
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Sql log backup error,
Robert Ouzen <=
|
|
|