Appendix C - Backing Up Stand-Alone 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:
-
Open a command prompt
-
In the command prompt window enter the following code exactly as it is shown below, and press Return:
OSQL -E -S %COMPUTERNAME%\CASEWISE
-
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. |
|---|
-
Type Exit at the prompt