ID #1265

During Branch DB creation an Error is showing every time. What should I do to resolve this problem?


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:

  1. Take backup of Fr6 Data.
  2. Stop Normal SQL Server Service.
  3. 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'.
  4. Open Sql Server Management Studio.
  5. Use the master database and detach msdb using "sp_detach_db 'msdb'" command.
  6. Rename the damaged msdb files (msdbdata.mdf and msdblog.mdf) in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory.
  7. Run the instmsdb.sql script from the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory.
  8. Restart the system and restart SQL Server normally.
  9. Restore your backup.

For more details please visit:


Tags: Database, Error Message, Message, Settings

Related entries:

You cannot comment on this entry