my database SQL 2005 gone to suspect mode (erp LN 6.1 fp5)
please advice , how to resolve.

thanks in advance

Hi,

You have 2 options .
1.Restore from backup
2.Recreate it.


if you do not have valid MSDB backup.you can try to run repair on it by using following steps:

1.alter database dbname set emergency
2.dbcc checkdb

syntax http://msdn.microsoft.com/en-us/library/aa258278(SQL.80).aspx

Try and revert.

All the best,
Sushil Kumar Mudaliar

On a second thought , if you wanna recreate it - do the steps as follows :

1.Detach db using :start sqlservr.exe -c -T3608
(note: you need to set the path for execution in cmd)

2.Rename msdb files which are damaged.

3.run the script insmsdb.sql available in install directory.

then restart the server normally.

Hope this helps .

Note : some time back this worked for me - with some other apps gone into suspect mode.

I try to execute the following query

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER


now the system is up. but the database is set to emergency. i could view the records.

how to change emergnecy to normal. any idea....

thanks in advance

Hi,

I assume by Now you must have resolved the issue - Kindly post the solution so that it will be Needful for any other members facing similar issue in near Futrure.