Skip to main content
Skip table of contents

How to delete and restart a broken SQL database

Sometimes there might be problems with the SMServer and the SQL database may be broken. This solution repairs the SQL databases.

These are the databases: DVRServer, WDServer, SMServer 

Step-by-step guide

  1. Go to the Master Server
  2. Shut down all VMS processes: WDServer, DVRServer, SMServer
  3. Open the SQL Management Studio. Use of administrator rights may be needed
  4. Go to "Databases"
  5. Right-click each database "DvmsData", "RecorderDB" and "WdContext" and delete the databases.
  6. Restart VMS services:WDServer, DVRServer, SMServer
  7. In the SQL Management studio, close the folder hierarchy to the root level and press refresh. Check that the "DvmsData", "RecorderDB" and "WdContext" databases are created.
  8. Test if the system works better

Optional steps: If there are problems with access rights try this:

3.1 Go to Security - logins - NT AUTHORITY\SYSTEM
3.2 Click "Server roles"
3.3 Select "sysadmin"
3.4 Press OK

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.