Microsoft SQL Server 2008 R2 Standard

What I would like to find out is what the size of the DB was at specific dates in the past. I don't have backups going back that far. The current log may or may not go back far enough.

Is there any way at all to retrieve that type of information?

1 Answer 1


Unless you capture that information on your own SQL Server does not record it anywhere. Most folks go by the backup size.

If you use 3rd party software to backup the server or where ever you store your database backups you might see if it has a history as well. If you have something like Netbackup Enterprise or other similar software it should keep at most the file name and size unless your backup admins purge that information as well, but most don't that I have worked with.

  • Thanks for the answer, I had figured as much but wanted to run it by the DBA community to make sure I didn't miss anything. The backups don't go back far enough in our case. Commented Apr 16, 2012 at 16:06
  • 1
    If you don't have a purge job set up, you can find all your backup sizes in msdb.dbo.backupset; I've used it to backtrack database sizes many times.
    – SqlACID
    Commented Apr 17, 2012 at 0:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.