Recently our development team migrated couple of sql server 2000 Databases onto SQL2K8R2.
Now we creating the backup strategy, and just had a doubt, that:
1) Compatibility level of those DB's still show 80, we asked the team if that can be changed to current , they had no clue. I searched on web, but could not find any such stuff which clarifies on what point should we or should we not change the compatibility level of the migrated db's.
2) For the Migrated DB's having compatibly 80, are we good to take compressed backups? I am just curious because if we try to restore on the same or upper version , it might not have any conflict.?
Please advice, thanks!