We have upgraded several SS 2005 (Std) databases to SS 2008 (Ent), moving from Windows Server 2003 to Windows Server 2008 (Datacenter). Not only do the restores take a very long time, but the restored databases are MUCH larger (e.g. 4x) than the same database in SS 2005. We have checked the obvious config options, but had no beneficial impact that reduces the database sizes. Any ideas what can be causing this?
Thanks very much!