Refreshing a Test System
Hi,
I was just wondering if you could validate something for me.
We have two Service Desk Plus systems running the same version of software, a Live and Test. Each use a separate SQL Server as reference. We've made changes to Live since this was setup and now want to refresh our test environment so the config and data of Live are replicated into the test environment.
Will a simple Full Backup of Live, and then Restore establish this ? Obviously we'd need to make sure the Webserver port and Database config is redone but the remaining question is Do we need to copy our Live SQL Database to Override the Test SQL Database as well ? (Or will the Restore do all the required SQL updates?).
Regards
Andrew
9120 MSSQL
I was just wondering if you could validate something for me.
We have two Service Desk Plus systems running the same version of software, a Live and Test. Each use a separate SQL Server as reference. We've made changes to Live since this was setup and now want to refresh our test environment so the config and data of Live are replicated into the test environment.
Will a simple Full Backup of Live, and then Restore establish this ? Obviously we'd need to make sure the Webserver port and Database config is redone but the remaining question is Do we need to copy our Live SQL Database to Override the Test SQL Database as well ? (Or will the Restore do all the required SQL updates?).
Regards
Andrew
9120 MSSQL