To check when a database was last backed up
-
Start your SQL Server
management program, as follows:
-
For SQL Server 2008: Click > >
-
For SQL Server 2005: Click > >
.
-
For SQL Server 2000: Click > > .
-
In your SQL Server
management program, expand the list of servers.
-
Expand .
-
Right-click the database
that you want to check and, on the shortcut menu, click
.
-
In the database
properties, the tab
shows the dates for the last database backup and the last database
transaction log backup.