Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 7 down vote accepted

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.

share|improve this answer
    
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. –  Reality Extractor Apr 16 '12 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 Apr 17 '12 at 0:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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