May 19, 2008 at 2:09 pm
Is there a way to find out the original size of both a database and log file? Is this stored in a system table somewhere?
Steve Jones - SSC Editor
May 19, 2008 at 2:23 pm
Is there some reason you need this?
I'm not sure this is stored as it's not really needed like it was in SQL 6.5 and previous.
Now if you restore, the backup creates the necessarily files and sizes.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 19, 2008 at 2:28 pm
I'm being asked by a software vendor whose products backend is sql. They want to know the original database size and it's creation date.
One Orange Chip
May 19, 2008 at 3:42 pm
You cannot find original size of a database.
May 20, 2008 at 8:23 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply