We plan to backup a SharePoint content database from Production to Test environment. The problem is, that storage on the SQL in Test isn't sufficient.
We have two SQL instances in Production, so my question now is, if we can restore the content database from one instance into the other and then mount it to a web application in the Test environment.
Example: We backup the SP content database from production SQL instance (A) and restore it into the second production sql instance (B) . Now we attach the restored database in production SQL instance (B) and mount the database on a web application in the Test SP server.
Note: All SQL instances are same version. Is this supported from SharePoint ?