Monday, February 20, 2012

msdb corrupted in sql 2005 sp2, how to start with a new one?

Hi,
I get many errors about SSIS and SQL Agent.
msdb should be corrupted.
is there some way to start with a brand new msdb?
I'm going to
-install a new sql 2005 instance
-upgrade it with sp2
-copy the new msdb from the second instance to the first instance
is that correct?
ThanksI dont think reinstallation is necessary. Totally new msdb database can be
created by executing the script located at your install directory under path
Driveletter\Program files\Microsoft SQL Server\MSSQL\Install
File name is instmsdb.sql.
Lets see what experts recommend......
Manu
"Federico Caselli" wrote:
> Hi,
> I get many errors about SSIS and SQL Agent.
> msdb should be corrupted.
> is there some way to start with a brand new msdb?
> I'm going to
> -install a new sql 2005 instance
> -upgrade it with sp2
> -copy the new msdb from the second instance to the first instance
> is that correct?
> Thanks
>|||How do you know msdb is corrupt? Is there any important information that you
may be losing by replacing msdb? What about a recent backup?
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Federico Caselli" wrote:
> Hi,
> I get many errors about SSIS and SQL Agent.
> msdb should be corrupted.
> is there some way to start with a brand new msdb?
> I'm going to
> -install a new sql 2005 instance
> -upgrade it with sp2
> -copy the new msdb from the second instance to the first instance
> is that correct?
> Thanks
>

No comments:

Post a Comment