Currently the database is on SQL server 2005 Workgroup edition.
This customer had a corrupt database last week, so I backed up their db and brought the copy in office and re-built the database. On 24th, I restored the fixed db on their server that time the size of the db was 7 MB and today i.e. on 26th when I checked the size now it’s grown to 7 GB. I tried to shrink the data file, now the size is reduced to 5 GB. They must have posted the 2000 transactions in last 2 days.
Also, when I checked the size of the back up files (backed up by the maintenance plan), the size on 24th was 7mb, and it grew to 2GB yesterday.
Can you please tell what could be the problem here and how do I resolve it?
Thanks for help in advance