Backing up a database

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.

See Also

Product TechNotes and FAQs

Licensing TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

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!