Answer:
There is no problem with FusionRetail6. This Problem arises when "MSDB" is corrupted on a particular system. Following the steps given below to solve the problem:
- Take backup of Fr6 Data.
- Stop Normal SQL Server Service.
- Start SQL Server with trace flag 3608 (allow you to detach msdb) going to the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn' directory and from a command prompt doing 'start sqlservr.exe -c -T3608'.
- Open Sql Server Management Studio.
- Use the master database and detach msdb using "sp_detach_db 'msdb'" command.
- Rename the damaged msdb files (msdbdata.mdf and msdblog.mdf) in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory.
- Run the instmsdb.sql script from the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory.
- Restart the system and restart SQL Server normally.
- Restore your backup.
For more details please visit: