This issue is caused by abnormal shutdown of the PC or server where PD is installed,
We have a huge power crisis in South Africa and load shedding affects clients that host PD on their Windows machines or VMs that require power to run,
Your database will not open due to SQL suspecting that the database is faulty you need to run the following steps to resolve this issue:
- Download SQL Management Studio
- Login as Administrator or SA user
- Open the database which will appear as SUSPECT in brackets
- Write the below query and execute the command
EXEC sp_resetstDBstatus [PDDB2];
ALTER DATABASE [PDDB2] SET EMERGENCY
DBCC checkdb([PDDB2])
ALTER DATABASE [PDDB2] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([PDDB2], REPAIR_ALLOW_DATA_LOSS)
Write this after you set the database to single user
ALTER DATABASE [PDDB2] SET MULTI_USER