Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Disaster Recovery and Availability

SQL Database Properties - Last Database Backup

Due to a network time skew some time ago, all of the databases on an SQL system now have the following information stamped on them..

Within Enterprise Manager (SQL 2000), The "Last Database Backup" timestamp for each database is showing the year 2025.
Our backup system runs incrementally daily and a weekly full. Unfortunately, the timestamp does not seem to be updating as the year is as I guess in the future.

Can anyone advise of a procedure so as I can wipe this time skew date from each of the databases?


Many thanks folks!

[573 byte] By [Belly] at [2008-3-3]
«« default folder
»» fields cannot be used in page headers or footers.
# 1

I believe (I'll double-check when the right people come in) that the "Last Database Backup" value comes from msdb..backupset. So, to remove the incorrect entries:

DELETE FROM msdb..backupset WHERE backup_finish_date > CURRENT_TIMESTAMP

KevinFarlee at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Disaster Recovery and Availability...
SQL Server
SQL Server Disaster Recovery and Availability

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified