How could I figure out the size of one database in 2004?
Linking 2004 information(mdf) with the current one I will obtain how many
points in % has grow up that database, but how' Is that information lost?
I unfortunately think so.
Thanks in advance and regards,
Enricexamnotes (Enric@.discussions.microsoft.com) writes:
> How could I figure out the size of one database in 2004?
> Linking 2004 information(mdf) with the current one I will obtain how many
> points in % has grow up that database, but how' Is that information lost?
> I unfortunately think so.
I'm not sure I understand the question, but if the question is "how can I
find out how which size the database had as some point in year 2004?", then
I'm afraid that the only way to find out is to dig up a backup from
that time and restore it.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Exactly, you perfectly understood it. I am afraid that such solution would
jeopardise the system. If I have to restore each database (to tell the truth
are more than 40 databases) and then compare these data with the current one
.
The next one I'll try be more explicit. English is not my mother tongue.
Thanks in advance,
"Erland Sommarskog" wrote:
> examnotes (Enric@.discussions.microsoft.com) writes:
> I'm not sure I understand the question, but if the question is "how can I
> find out how which size the database had as some point in year 2004?", the
n
> I'm afraid that the only way to find out is to dig up a backup from
> that time and restore it.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>|||> jeopardise the system. If I have to restore each database (to tell the
> truth
> are more than 40 databases) and then compare these data with the current
> one.
Then one thing you could do is log to an external system the results of,
say, sp_spaceused for each database, and do so periodically (e.g. daily,
w
ly, monthly). Then you will have a running history going forward atleast (given that it won't help you for historic data).|||Thanks Aaron,
"Aaron Bertrand [SQL Server MVP]" wrote:
> Then one thing you could do is log to an external system the results of,
> say, sp_spaceused for each database, and do so periodically (e.g. daily,
> w
ly, monthly). Then you will have a running history going forward at> least (given that it won't help you for historic data).
>
>
