Server at offshore we are using SQLSERVER2008 and as well client is also using SQLSERVER2008. Recently offshore server we have updated to SQLSERVER2008 R2. Recently i took a backup from clinet place and i am trying to restore, it is showing me the compatability issue. I would like to know...what will be the impacts.
So the backup you took is from the client @ SQL Server 2008? Then your offshore system is running @ SQL Server 2008 R2? Are you trying to restore the backup you took from the client to the offshore instance of SQL? If all these questions are YES, then it should restore, please provide error messages that you receive.