Microsoft SQL Server forum - Original Data and Log size

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Original Data and Log size

rcamarda

2005-09-21, 7:23 am

How can I find out the original size of the Data and Log files?
TIA
Rob

Simon Hayes

2005-09-21, 11:24 am

I don't believe that information is stored anywhere - the system tables
and procs all seem to show only the current size. Documenting your
server build and all modifications to your database settings is
probably the best way to make sure you have a history of things like
that..

Simon

rcamarda

2005-09-21, 8:23 pm

Boo! Well, it is good avice Simon; my trouble is I did not set up the
databases, our vendor did. I wanted to check myself, as I suspect the
tables were created with the default of 1mb (they are now 12GB
combined, mostly favoring the log)

Sponsored Links