Web Development

General discussion

Gravatar
0 Votes
Locked

SQL Server 7.0 - Transaction Logs

By sonja-pfitz ·
We are running SQL Server 7.0 to manage a few databases. We have set up the maintenance plans for the three databases but only one of them seems to be recording transactions logs. All maintenance plans are identical. These transaction logs and backup logs are mission critical for us. Why are these transaction logs not recording? Thank you for your help.

Sonja Pfitz
Melbourne Australia

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

SQL Server 7.0 - Transaction Logs

by jmiller1 In reply to SQL Server 7.0 - Transact ...

Are the jobs finishing properly? Or are they coming back as failed? Any error messages in the server's error logs? The first thing that comes to mind is to make sure the 'SELECT INTO/BULK COPY' and 'TRUNCATE LOG ON CHECKPOINT' options are not seton the 2 failing databases.


jm

gravatar
Collapse -

SQL Server 7.0 - Transaction Logs

by sonja-pfitz In reply to SQL Server 7.0 - Transact ...

Poster rated this answer

gravatar
Collapse -

SQL Server 7.0 - Transaction Logs

by sonja-pfitz In reply to SQL Server 7.0 - Transact ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums