You are currently reviewing an older revision of this page.
Document Type: FAQ Product(s): SELECT Server XM Edition Version(s): All Original Author: Bentley Technical Support Group Legacy Document Number: 9994
Document Type: FAQ
Product(s): SELECT Server XM Edition
Version(s): All
Original Author: Bentley Technical Support Group
Legacy Document Number: 9994
It is good practice to have a backup of critical data such as that contained within your SELECT Server 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'javascript:void(null);' 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'javascript:void(null);' 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 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!