ID #1265

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

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:

  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:

  1. http://www.rancelab.com/help/fr6_location_master.htm
  2. http://www.rancelab.com/faq/content/13/186/en/how-to-remove-a-corrupt-sql-server-2005-express-instance.html
  3. http://www.rancelab.com/help/fr6_backup_of_database.htm
  4. http://www.rancelab.com/help/fr6_backup_database.htm

Tags: Database, Error Message, Message, Settings

Related entries:

You cannot comment on this entry