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.
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL Server 7.0 - Transaction Logs
Sonja Pfitz
Melbourne Australia