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.