msdb (syspect) -- sql server new users

sql server new users : msdb (syspect)

Chen
1/3/2005 12:57:23 PM

My Sql server msdb database demaged.
I did not backuped it before.
I copy the msdbdata.mdf and msdblog.ldf from other SQL database.
But not working.
How can I fix it
Thank

M
1/3/2005 2:53:55 PM

Thanks
I run Instmsdb.sql and get:
----------------------------------
Starting execution of INSTMSDB.SQL
----------------------------------
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Configuration option 'allow updates' changed from 0 to 1. Run the
RECONFIGURE statement to install.
Server: Msg 926, Level 10, State 1, Line 57
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.
Server: Msg 926, Level 10, State 1, Line 1
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
sp_dboption command failed.
Server: Msg 926, Level 10, State 1, Line 2
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure
.....
[quoted text, click to view]

Fredrik Wahlgren
1/3/2005 10:35:49 PM

[quoted text, click to view]

I hope this URL will help:

http://www.spaceprogram.com/knowledge/sqlserver_recover_emails_received.html

/ Fredrik

Cristian Lefter
1/4/2005 12:05:19 AM

If the msdb is lost you can rebuild it running Instmsdb.sql script or
reinstalling the latest service pack installed on your server.

- Cristian

[quoted text, click to view]

Chen
1/4/2005 8:32:16 AM

It works

Thank you very much

[quoted text, click to view]

Cristian Lefter
1/4/2005 2:44:45 PM

Run this script just before you run INSTMSDB.SQL:

USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO

delete from sysdatabases
where name='msdb'
GO

(The INSTMSDB.SQL checks if sysdatabases table contains an entry for 'msdb'
database. If not, it will create a new msdb database)

- Cristian

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn