SQL Server 2005/2008 backup and restore questions...
Everything is running on 64bit Enterprise Edition.
We have a SS 2005 based 15TB data warehouse with lots of filegroups and files mapped to all sorts of direct attached disks.
We are moving to SS 2008 on a SAN where we won't need to have all the drive mappings that we do now.
1. Is it possible to restore a SS 2005 backup to SS 2008? If so do I just need to change the compatibility level after restore to take advantage of the 2008 features like page level compression etc...
2. Is it possible to remap the file mount points during restore? ie I may have filegroup GLOBAL that contains files: global_1.ndf, global_2.ndf and global_3.ndf mapped to drives X, Y, and Z respectively. X,Y,Z are not going to exist on the new SAN so can I change this during the restore process that so those files map to drive G for example?