Settings

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: SQL

Related entries: -

Last update: 2012-01-21 07:56
Author: Admin
Revision: 1.1

Digg it! Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry