Issue
SQL Management Studio Express is not installed and ContinuumDB needs to be backed up.
Environment
CyberStation Standalone
Cause
Need to backup a standalone database but have no internet access to download & install SQL Management Studio Express
Resolution
- Open command prompt.
-
Type sqlcmd -SComputername\sqlexpress where Computername is the name of the computer. Press Enter.
You should see this: 1> -
Type backup database continuumdb to disk = 'mycontinuumdb.bak with init; Press Enter
You should see this: 2> -
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.