Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2010-05-13 : 07:47:00
|
| I have one SQL Server with Several Instances . All Instances are at version 9.0.4035. I use Maintenance 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? |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2010-05-13 : 09:35:21
|
| Dropped my Maintenance plan and recreated it. It is now updating the DB properites page properly. |
 |
|
|
|
|
|
Tlog backups not showing as being run in MGTStudio