Applies To | |||
Product(s): | SELECTserver | ||
Version(s): | XM Edition - present | ||
Environment: | N/A | ||
Area: | N/A | ||
Subarea: | N/A | ||
Original Author: | Bentley Technical Support Group | ||
It is good practice to have a backup of critical data such as that contained within your SELECTserver database. This article details how to create such a backup.
In order to backup of a MSSQL or MSDE database you will need to make use of the osql tool. Open a command prompt and type the following, replacing what is in red with the applicable information:
osql -S MyServerName -U user -P password -Q "BACKUP DATABASE [Database Name] TO DISK = N'c:\SSXM_DB_BACKUP.bak' WITH NOFORMAT, INIT, NAME = N'[Full Backup]', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
Example:
osql -S DOEHM27519EXT -U sa -P sa -Q "BACKUP DATABASE [SELECTServer] TO DISK = N'c:\SSXM_DB_BACKUP.bak' WITH NOFORMAT, INIT, NAME = N'[Full Backup]', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
This example will generate a database backup named SSXM_DB_BACKUP.bak, located in the c:\ directory.
Bentley Technical Support KnowledgeBase
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!