If a plant is on a really old version for example 2005 SQL Studios will it effect a test server if a test server has the updated version with old databases from the main server?
You can run older Database backups on a newer version of SQL, but not the other way around. However, this is not recommended. The ideal situation would be to have matching Primary and Test Servers. That way, you have the least amount of risk when testing since both servers would have the same Operating System, SQL, App versions, etc…
.
