Database size shrunk

I will like to request for understanding with regards to SQL data size.

On Friday, 21 March, I checked from the SQL Server Enterpise Manager that my Data Size was 30 MB.

I then had my database quota size increased.

However, on Monday 24 March, I noted that the data size has shrunk to 24 MB even though my client has added about 7k+ of records to the database since.

Today on 25 March, the database showed 15 MB instead. I checked my records and there was nothing lost in them. The number remains the same or slightly higher. This is because they have almost completed the porting of the data.

I am confused as to the difference in the display of Data Size. It has lead me to a wrong decision earlier to upgrade to 45 MB when in actual fact, the data doesnt even take more than 16 MB.

I have during the time truncated the transaction logs. Could this be the cause of the database size to shrink?Check whether AUTO_SHRINK option is used.|||Originally posted by Satya
Check whether AUTO_SHRINK option is used.

Thanks for replying

I just checked and AUTO_shrink is off

Would there be anything else that could cause it to shrink?sql

Database size

Hi!
Is it possible to ask a database (using a SQL statement) how big it is?
Regards
/AndersHi
Yes, It is
sp_helpdb 'databasename'
"Anders Wåhlin" <anders.wahlin@.erv.ericsson.se> wrote in message
news:bnoeat$k7k$1@.newstree.wise.edt.ericsson.se...
> Hi!
> Is it possible to ask a database (using a SQL statement) how big it is?
> Regards
> /Anders
>|||sp_spaceused will display size of current database,
optionally you can also pass an argument to this procedure
<tablename> to know size of a particular table.
>--Original Message--
>Hi!
>Is it possible to ask a database (using a SQL statement)
how big it is?
>Regards
>/Anders
>
>.
>

Database Restore

Hi All,
Can I restore a SQL 2000 backup file in SQL 7.
Thanks & Regards
Balaji.THi,
No, it is not possible to restore the backup file from later versions (SQL
2000) to lower versions. (SQL 7 or old)
To perform this type of activity, you may need to use either DTS or BCP
OUT/IN.
Thanks
Hari
MCDBA
"Balaji" <anonymous@.discussions.microsoft.com> wrote in message
news:1201a01c3f5ea$5b128a80$a001280a@.phx.gbl...
> Hi All,
> Can I restore a SQL 2000 backup file in SQL 7.
> Thanks & Regards
> Balaji.T