How to backup ContinuumDB from a command prompt.

Issue

SQL Management Studio Express is not installed and ContinuumDB needs to be backed up.  

Product Line

Andover Continuum

Environment

CyberStation Standalone

Cause

Need to backup a standalone database but have no internet access to download & install SQL Management Studio Express

Resolution

  1. Open command prompt.
  2. Type sqlcmd -SComputername\sqlexpress   where Computername is the name of the computer. Press Enter.
    You should see this: 1>
  3. Type backup database continuumdb to disk = 'mycontinuumdb.bak with init;    Press Enter
    You should see this: 2>
  4. Type go and press Enter
    You should see something like this: Processed ### pages for database 'continuumdb', file 'ContinuumDev' on file 1. Processed ### pages for database 'continuumdb', file 'ContinuumLog' on file 1. BACKUP DATABASE successfully processed ### pages in ###.# seconds.

On a default SQLExpress install (on the C Drive) the file created from the above command (mycontinuumdb.bak) will be created in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.