Suggested to have a directory on your server for MANEX. Within that directory you might have some sub-directories
DailyBackup
Data
ManexDesktop
Within the Data Directory
Create two sub-directories
Live (this is more than likely where your live data resides)
Test (this is where you will be creating your Test data)
Go to your DailyBackup directory and copy the path as shown
Open your SQL Server Management
Select Server Name
Log In using SQL Server Authentication
You can use the attached script file at the bottom of this article. This script will allow you to make a quick backup of the ManEx data base and you can modify where you want the .bak file to be created in.
Open the script in your SQL manager.
Paste the file path that you copied from the Step above
also Suggested to place at least the date that the backup is being created into the name.
Once you have modified the settings in the script to what you want, execute the script. The backup will be created in that location.
Suggested to go to the DailyBackup directory and confirm that the Backup of your Live data has been generated
Return to the SQL Manager
Once logged into the Server you can then right-click on Database
Select Restore Database.
While in the General Page
select Device
Then depress the browse button
Within the Select Backup Devices screen depress the "Add" button
Within the Locate Backup File screen
Locate or paste the File path of where your Backup files is located
You might see it right away or you might have to change to "All files"
The Select the BAK file and make sure that it is displayed in the File Name field.
Depress OK
You will be returned to the Select backup devices screen
You will see your backup media populated
Depress the OK button
The General Page will look similar to this
Make sure to type in the desired Database name. In this example I selected "ManexTest"
Then select the Files Page from the left.
While in the File Page you will want to check Relocate all files to folder
Paste in the file path where you wish to keep the database
then also confirm within the Restore As field that the MDF and LDF file name matches what you are naming this database. (Sometimes it might retain the Original Database name in the restore as fields)
Then go into the Options Page
Check to see if Tail-Log Backup items are active.
If they are you will want to make sure to uncheck these
Depress the Ok Button
You should then see a progress bar in the upper right hand corner
Once finished you will see the following message.
Upon returning to the SQL Manager you should see your new database has been restored.
Return to the K:\Manex\ManexDesktop directory
Within the ManexDesktop we have crated two individual Directoried
LIVE
TEST
go to where you have your Live Manex Desktop directory setup
Select all
Copy the Live Desktop Directory
Go to the ManexDesktop\Test directory and Paste
While in the ManexDesktop\Test directory
Edit the ManexSQL.ini
Make sure the database is pointing to the MANEX_Test
Now we will setup the test site for Manexcloud(Web) so you can also test Manexcloud(web) functionality on the test system
Go to the location you setup the Manexcloud(Web) for your live system
Create a directory for the test Manexcloud
Copy contents from your live Manexcloud to Test Manexcloud
You will need to open the Webconfig file and change the catalog from pointing to Manex database to the test database you created. See highlighted section in yellow below. Please note if you setup a user ID and password for SQL authentication in the SQL manger for your live system you will need to do this again for your test system
Save Changes
Now we need to setup the test Manexcloud website. You would set this up the same way you did the live site following the original instructions provided to you at this KB article. Setup manex as a Sub-Domain or Stand-Alone Website. Only you are pointing to the test Manexcloud directory you just setup.
You also have to go into the test_manex system into system settings.exe and go under system appearance to modify the web URL to use the test site.
Please note you will have to do this step each time you restore the test database.
You will want to make sure that the appropriate people that will be reviewing the Test system have access to the following . . .