Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-12-19 : 00:00:08
|
| Dear All,after searching continuously for removing the suspect mode of MSDB database, i've found a great article in net.but i dont understand how to proceed. please explain me the steps....1. Detach the damaged msdb. You can't just detach msdb because you're not allowed to detach system databases. However, you can if you start the server with trace flag 3608. I did this by shutting down the server, navigating to the directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn' and doing the following: start sqlservr.exe -c -T3608 2. Move or rename the damaged msdb files (msdbdata.mdf and msdblog.ldf in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory) 3. Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory 4. Shutdown and restart the server without the 3608 trace flagVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 00:25:00
|
| Yes, that's the way. But you have to recreate jobs and dts packages (if on sql2k). |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-19 : 01:01:17
|
| ok i'l do that...but what is the step 1 here? i did not get >>sqlservr.exe -c -T3608how can i shutdown sql serever?....i went services and restarted the services...i've found to do that in 2k.but where should i add that in 2k5?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 03:45:47
|
| Works same way in sql2k5. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-20 : 04:26:12
|
| what should i type there at startup parametre? please rmiao help me out in thisVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-12-20 : 05:18:12
|
quote:
Originally posted by sunsanvin
what should i type there at startup parametre? please rmiao help me out in thisVinodEven you learn 1%, Learn it with 100% confidence.
did you follow the instructions? the first step is to shut down the sql server. then navigate to the folder where it is installed (using the command prompt). ONce in that directory you issue the start command 'start sqlservr.exe -c -T3608'is that what you did?-ec |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-26 : 01:24:00
|
| now i got the clear idea.....previously ididn't do that....thank you eyechartVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
msdb recreate