1 Problem review
On-site personnel feedback, the server has experienced an abnormal power outage, after the power is restored, the SMC2.0 cannot log in.
2 Problem Handling and Location Process
After the trace log is collected on the site, the SMC program is found to be abnormal.
After remotely accessing the smc server through Teamview, log in to the smc20db database through the sqlcmd command line, and prompt the database to be in the SUSPECT state
1. Open Microsoft SQL Server Management Studio and connect to your database
2. Click the New Query button
3. Paste the following SQL script into your New Query page replacing [YourDatabase] with the name of your database.
EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER
4. Click Execute
An abnormal power outage can cause the SQL Server database to be in an abnormal state (SUSPECT state).
It is recommended that the customer check the relevant circuits to ensure that the smc server is powered normally to prevent the video conference service from being affected.
3 problem root cause analysis summary and solution
An abnormal power outage can cause the SQL Server database to be in an abnormal state (SUSPECT state).
It is recommended that customers check the relevant circuits to ensure that the smc server is powered normally to prevent video conference services from affecting.
