You are currently reviewing an older revision of this page.
Document Type: TechNote Product(s): SELECTserver Version(s): XM Edition - present Original Author: Bentley Technical Support Group
Document Type: TechNote
Product(s): SELECTserver
Version(s): XM Edition - present
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.
Product TechNotes and FAQs
Licensing TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!