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 |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2009-02-08 : 09:36:01
|
| I had ran the above command from the command line because my "msdb" is hose, I was going to move the mdf & ldf files or rename them and then run the instmsdb.sql script and restart the server but after running the command in the subject line I'm still waiting the a command line response. How long should it be or should it have taken this long (1hr so far) before I get a command prompt? Help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-08 : 09:40:16
|
| http://support.microsoft.com/?id=224071 |
 |
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2009-02-08 : 09:57:43
|
| The link doesn't explain or tell me how to start SQL Server? Do I open another command line and try to start it from there? It will not start from "Servers", I receive a message just say it could not start on Local Computer. Should I shut down the server and restart? |
|
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2009-02-08 : 10:00:41
|
| Error: 8355, Severity: 16, State: 1.2009-02-08 08:41:05.26 spid5s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker. 2009-02-08 08:41:05.26 spid5s Recovery is complete. This is an informational message only. No user action is required. |
|
|
|
tonymorell10
Yak Posting Veteran
90 Posts |
Posted - 2009-02-08 : 10:51:01
|
| The instmsdb script should only take a few minutes to run.Go to Settings->Control Panel->Administrative Tools->Services. See if the SQL Server service is started (it may still be running with the T3608 flag). If it is running, right click on the service and select Restart. If the service is stopped, try starting it. If the service refused to start, reboot the server. If the service still fails to start, you may have to start over and run instmsdb again. |
|
|
|
kappa02
Yak Posting Veteran
65 Posts |
Posted - 2009-02-08 : 11:37:22
|
| I want to run the instmsdb script but I can't, when I open up a new command line and type instmsdb.sql and execute the script I get;Starting execution of INSTMSDB.SQL----------------------------------Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.Msg 927, Level 14, State 2, Line 63Database 'msdb' cannot be opened. It is in the middle of a restore.Msg 5052, Level 16, State 1, Line 3ALTER DATABASE is not permitted while a database is in the Restoring state.Msg 5069, Level 16, State 1, Line 3ALTER DATABASE statement failed.Msg 927, Level 14, State 2, Line 2Database 'msdb' cannot be opened. It is in the middle of a restore.Msg 2745, Level 16, State 2, Line 4Process ID 53 has raised user error 50000, severity 20. SQL Server is terminating this process.Msg 50000, Level 20, State 127, Line 4A problem was encountered accessing msdb. INSTMSDB.SQL terminating.Msg 0, Level 20, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.Is it because the first command line where I had type "sqlservr.exe -c -T3608" is still proccessing? I haven't got a command prompt back from that screen. |
|
|
|
|
|
|
|
|
sqlservr.exe -c T3608