I have an issue with one database. The issue is as follows:
The database is being running on SQL Server 2000 Standard for the last 6 years in Full Recovery mode.
In the beginning of this summer the database was about 5GB.
Since then, the only thing we did beyond normal usage is some extensive deletions.
This week, there was a problem with the PC and I was forced to do a backup and restore it on an SQL Server 2008R2 Express and set the database in 2008 mode.
The backup file was about 1GB. When I restored it, the MDF was 9GB of size! I checked the old MDF and it was of the same size.
I checked the size of the tables and they cannot reach the 9GB reported!
I did a shrink but the size did not change.
Any clues or where to check?
Is there a chance that the Full Recovery, can affect the size of the MDF files?
I am thinking of setinng the recovery model to Simple, back-it-up and restore it. Is it going to make a difference? Can I do it on a live database?
Thanx in advance!
UPDATE:The initial size of the database is 1306 MB
UPDATE2 sp_spaceused: Database Size=8646.88 MB Unallocated Space= 0.00 MB
reserved=1336984 KB data=1020376 KB index_size=210408 KB unused=106200 KB