These commands can help you resolve issues with the SQL Server database that runs under memoQ server.

To use these commands, open the sqlcmd program. This is the SQL Server command line, which will be on the server computer if SQL Server is installed.

If SQL Server is on a different computer than memoQ server: It is recommended that you log on to the SQL server (rather than to the memoQ server) computer through Remote Desktop, and run the commands there.

warning-paragraph

Do not make changes to your system unless you know exactly what you are doing, and everything written here is clear to you.

warning-paragraph

Use these commands entirely at your own risk: Kilgray takes no responsibility for damages that occur when you use these commands. They are extremely dangerous in inexperienced hands. Also make sure to back up the database before you make any changes. It is also highly recommended that you take at least a crash course in SQL Server administration before you proceed.

Connecting to a database instance (example below shows a local instance)

Displaying the exact version of the MS SQL Server instance

Detaching a database from SQL Server: Use this before moving database file

Attaching database: Use this after you move the database file

Adding db_owner database level role for a user

Adding fixed server roles for a user

List databases

View the physical path of the MemoQServer.mdf and MemoQServer_log.ldf files

Back up database manually

Restore database manually