Wednesday, 13 August 2014

When was the last successful backup in sqlserver?

Just right click on the Database and click on properties on the sql management studio.

On top of window the last full backup completion time and log backup completion time is shown.This is the simplest way of finding the success of a daily backup without even typing a command.

No comments:

Post a Comment