Appendix C Backing Up Standalone Data
This section is only relevant if you are upgrading a stand-alone version of Evolve Suite.
|
|
The user running the SQL Server service must have write access to the chosen backup folder. To check the properties of the service, select Start > Control Panel > Administration Tools > Services, highlight SQL Server (MSSQLSERVER) and go to Action > Properties (or right click and select Properties). The Log On tab shows which user the service logs on as – usually Local System. |
To backup your stand-alone data:
1.Open a command prompt
2.In the command prompt window enter the following code exactly as it is shown below, and press Return:
OSQL -E -S %COMPUTERNAME%\CASEWISE
3.Enter the following code and press Return after each line:
Backup database CorporateModeler11 TO DISK = ‘<location>\<filename>.bak’ 2> Go
|
|
<location> is the location where you want to save your backup file, and <filename> is the name of the file. For example, <location> could be “C:\temp” while <filename> could be “MyDatabase”, resulting in the following <location>\<filename>.bak: “C:\temp\MyDatabase.bak” When the backup has finished the message: “BACKUP DATABASE successfully processed” is displayed. |
4.Type Exit at the prompt
Restoring Data
Restoring Data
This section is only relevant to stand-alone versions and obviously requires that you have previously backed up the data.
To Restore Data in a Stand-alone Database:
1.Open a command prompt
2.In the command prompt window enter the following code exactly as it is shown below, and press Return:
OSQL -E -S %COMPUTERNAME%\CASEWISE
3.If the Evolve Database already exists in MSDE/SQL Server Express, enter the following code:
1> Restore database CorporateModeler11 from disk =
‘<location>\<filename>.bak’ with replace 2> Go
If the Evolve Database does not exist, enter the following code to create the database and restore your data
Create database CorporateModeler11;
2> Go
3> Restore database CorporateModeler11 from disk =
‘<location>\<filename>.bak’ with replace 4> Go
|
|
<location> is the location where you saved your backup file, and <filename> is the name of the file. |
Appendix D Using Terminal Server
A Terminal Server installation involves one copy of the Evolve Suite client software being installed on a machine with Microsoft Terminal Services enabled, which is accessed by many users.
Quest supports installations that match the environment described in this chapter, however you can adapt this setup and use it with other remote access technologies, such as Citrix, as long as they are 100% compatible with Microsoft Terminal Services.
System Requirements
System Requirements
Please refer to the system requirements documents available on the Quest website for further details.
|
|
WHO SHOULD PERFORM THESE ACTIONS? The majority of the tasks in this chapter should be performed by a System Administrator, however there are some tasks for a nominated Evolve user. |