Records in this category
- I want to format my computer. What should I do?
- Error message “failed due to the following error: 80040154”
- How to disable the question “Service Mode?” in one of counter?
- How to choose hosting service and configure FTP for Fr6?
- How to utilize standard barcode which already comes per-printed on a product?
- Is it possible to manually adjust my weighing scale barcode denominations in RanceLab® FusionRetail™ 6?
Tags
Sticky FAQs
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:
- 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:
Tags: SQL
Related entries: -
Last update: 2012-01-21 07:56
Author: Admin
Revision: 1.1
You cannot comment on this entry
