did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to the
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
Ed
Hi
Do a complete index rebuild and an update statistics.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:

> I did an upgrade of a site system, computers and servers from NT4 server and
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>