May 13, 2010 at 5:44 am
I have one SQL Server with Several Instances . All Instances are at version 9.0.4035.
I use Mainatenance Plans to do nightly FULL backups and TLOG backups every 2 hours during business hours.
On one of my instances only.. the TLOG backups are running on schedule (and finishing successfully) but when I go into Management Studio and check the properties of each database (right click on database and choose properties) the Last Database log backup says NONE for each database.
Also, when I run a TLOG backup manually and THEN check the properties via management Studio it now says that a Database log backup was run.
Does anyone know why when the TLOG backups are run via a Maintenance plan it is not showing up as being run in the database properties via Management Studio?
May 13, 2010 at 7:35 am
Dropped my Maintenance plan and recreated it. It is now updating the DB properites page properly.
May 13, 2010 at 10:19 am
I have tested on my server and I had correct last log backup date.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply