How to back up and restore ShareScan 5.2 LocalDB database
Article # 3016722 - Page views: 262
Information on how to back up and restore the ShareScan 5.2 SQL Express LocalDB 2012 database
- Open a Command Prompt as Administrator
- Go to the Database Tools Directory
- The Database tools are located in the [InstallDir]\Server\Tools\Database
- i.e. C:\Program Files (x86)\Nuance\ShareScan5.2\Server\Tools\Database
- Change directory to the Database directory (given above) by using the command such as the following.
- CD C:\Program Files (x86)\Nuance\ShareScan5.2\Server\Tools\Database
- Note: do not edit any of the .cmd files.
- For SQL Express LocalDB 2012, the [SQLSERVER] is "(localdb)\.\eCopyShareScan"
- Run the command to back up the database
- usage: db_backup.cmd [SQLSERVER] [db install user] [db install pwd] [BackupFilePath]
- i.e. db_backup.cmd (localdb)\.\eCopyShareScan sa e+C0py2007_@x c:\ShareScanBackup\SS-DB-backup-Date
- Run the command to restore the database
- usage: db_restore.cmd [SQLSERVER] [db install user] [db install pwd] [RestoreFilePath] [DatabaseUser] [DatabasePassword]
- i.e. db_restore.cmd (localdb)\.\eCopyShareScan sa e+C0py2007_@x c:\ShareScanBackup\SS-DB-backup-Date eCopy e+C0py2007_@x