 |
 |
|
|
This topic explains how to backup an IRIS SQL database when using a windows command prompt.
This method is typically used when a management studio function is not available; this is the case when using SQL Server 2000 (MSDE). It covers performing a restore from the \iris\data\sqlbak directory.
Please read all the information in this factsheet before starting the restore.
1. From the computer that holds the IRIS database, click Start, select Run, type: CMD and click OK.
2. This will open a Command Prompt window.
3. Change to the IRIS folder. Type: cd\iris and press ENTER.
4. Type: OSQL -E –Sservername/irispractice and press ENTER. The cursor moves down to a new line with 1>
Servername is the name of the computer.
5. Type the following command to run the Restore:
restore database IRIS from disk = “C:\iris\data\sqlbak\IRIS.BAK”
6. Press ENTER.
7. Type GO and press ENTER to start the Restore.
8. There will be a pause while the restore takes place ending with a message similar to the following:
Processed 12345 pages for database 'iris', file 'IRIS' on file 1.
Processed 2 pages for database 'iris', file 'IRIS_log' on file 1.
RESTORE DATABASE successfully processed 12345 pages in 200 seconds (1 MB/sec)
9. Type Exit and press ENTER.
10. Type Exit and press ENTER again.