I'm going to be migrating a DB to a new server in the next couple weeks, and have a question. The DB in question has several tables / indexes compressed (page compression) to keep the physical size down.
Currently, I migrate by running a backup, taking the original DB offline, copying the backup to the new server and restoring.
So, simple question. Will the compression remain "on" if I move the DB that way?