<div>
Do you have a backup?<br />
<br />
If so, restore it (<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp</a>). &nbsp;If not, you can use the REBUILDM utility to do it. &nbsp;Rebuildm rebuilds the master database, so make sure you back it up first, cause you'll have to restore it after you run the utility.<br />
<br />
Brett
</div>


Do you have a backup?

If so, restore it (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp]).  If not, you can use the REBUILDM utility to do it.  Rebuildm rebuilds the master database, so make sure you back it up first, cause you'll have to restore it after you run the utility.

Brett

<div>
<div class="content wysiwyg-content">
I have accidentally deleted the sysobjects table in the MSDB Database..<br />
Now the entire database is not accessible..<br />
<br />
when i executed sp_databases, i get the error<br />
<br />
Invalid object name : &nbsp;MSDB.dbo.Sysfiles<br />
<br />
is there any way to create the MSDB again without re-installing the SQL Server instance??<br />
<br />
Viggee
</div>
</div>


I have accidentally deleted the sysobjects table in the MSDB Database..
Now the entire database is not accessible..

when i executed sp_databases, i get the error

Invalid object name :  MSDB.dbo.Sysfiles

is there any way to create the MSDB again without re-installing the SQL Server instance??

Viggee

Recreating MSDB Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.