Checking when a database was last backed up

To check when a database was last backed up

  1. Start your SQL Server management program, as follows:

    • For SQL Server 2008: Click All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio

    • For SQL Server 2005: Click All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.

    • For SQL Server 2000: Click All Programs > Microsoft SQL Server > Enterprise Manager.

  2. In your SQL Server management program, expand the list of servers.

  3. Expand Databases.

  4. Right-click the database that you want to check and, on the shortcut menu, click Properties.

  5. In the database properties, the General tab shows the dates for the last database backup and the last database transaction log backup.