PHWinfo banniere

Titres
PORTAIL ANNUAIRE ARTICLES COMPARATEUR HÉBERGEURS DEVIS FORUMS RÉDUCTEUR D'URL
Précédent   PHWinfo > Forums Hébergement > Forum Hébergement serveur > ms.sqlserver.server > sql 2005 - msdb suspect
S'inscrire FAQ Membres Recherche Messages du jour Marquer les forums comme lus
sql 2005 - msdb suspect

Réponse
 
LinkBack Outils de la discussion
Vieux 31/08/2008, 17h28   #1
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut sql 2005 - msdb suspect

Hi all,

All of a suddent yesterday morning one of my DEV SQL Boxes started reporting
MSDB as suspect. I tried to follow the instructions outlined in
http://winzenz.blogspot.com/2006/09/...databases.html to
restore MSDB, however when I try to start sql server using the trace flag I
get the following error:

Your SQL Server installation is either corrupt or has been tampered with
(SQL Registry Version not Same as Server). Please uninstall then re-run
setup to correct this problem.

Any ideas?

TIA!


  Réponse avec citation
Vieux 31/08/2008, 20h55   #2
John Bell
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: sql 2005 - msdb suspect


<paramr@community.nospam> wrote in message
news:%23TWtt43CJHA.4176@TK2MSFTNGP04.phx.gbl...
> Hi all,
>
> All of a suddent yesterday morning one of my DEV SQL Boxes started
> reporting MSDB as suspect. I tried to follow the instructions outlined in
> http://winzenz.blogspot.com/2006/09/...databases.html to
> restore MSDB, however when I try to start sql server using the trace flag
> I get the following error:
>
> Your SQL Server installation is either corrupt or has been tampered with
> (SQL Registry Version not Same as Server). Please uninstall then re-run
> setup to correct this problem.
>
> Any ideas?
>
> TIA!

Hi

Do you get any information in the SQL Server log?

You should still be able to start up SQL Server with

start sqlservr.exe -c -T3608

The comments on the article you posted indicate that you may need to do more
than what was just in the article and force the creation of a new database,
this is also reflected in

http://groups.google.com/group/sql-s...ing-msdb?hl=en

Alternatively if you have a backup of MSDB it could be restored and
detatched on another server and then replace the existing files with it.

John

  Réponse avec citation
Vieux 01/09/2008, 00h48   #3
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: sql 2005 - msdb suspect

Thanks. That worked.


"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:%235qZk45CJHA.5060@TK2MSFTNGP03.phx.gbl...
>
> <paramr@community.nospam> wrote in message
> news:%23TWtt43CJHA.4176@TK2MSFTNGP04.phx.gbl...
>> Hi all,
>>
>> All of a suddent yesterday morning one of my DEV SQL Boxes started
>> reporting MSDB as suspect. I tried to follow the instructions outlined in
>> http://winzenz.blogspot.com/2006/09/...databases.html to
>> restore MSDB, however when I try to start sql server using the trace flag
>> I get the following error:
>>
>> Your SQL Server installation is either corrupt or has been tampered with
>> (SQL Registry Version not Same as Server). Please uninstall then re-run
>> setup to correct this problem.
>>
>> Any ideas?
>>
>> TIA!

> Hi
>
> Do you get any information in the SQL Server log?
>
> You should still be able to start up SQL Server with
>
> start sqlservr.exe -c -T3608
>
> The comments on the article you posted indicate that you may need to do
> more than what was just in the article and force the creation of a new
> database, this is also reflected in
>
> http://groups.google.com/group/sql-s...ing-msdb?hl=en
>
> Alternatively if you have a backup of MSDB it could be restored and
> detatched on another server and then replace the existing files with it.
>
> John



  Réponse avec citation
Réponse


Outils de la discussion

Règles de messages
Vous ne pouvez pas créer de nouvelles discussions
Vous ne pouvez pas envoyer des réponses
Vous ne pouvez pas envoyer des pièces jointes
Vous ne pouvez pas modifier vos messages

Les balises BB sont activées : oui
Les smileys sont activés : oui
La balise [IMG] est activée : oui
Le code HTML peut être employé : non
Trackbacks are oui
Pingbacks are oui
Refbacks are oui


Fuseau horaire GMT +1. Il est actuellement 07h31.


Édité par : vBulletin® version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5 Tous droits réservés.
Version française #16 par l'association vBulletin francophone
PHWinfo est un site Éducation Sans Frontières ©2000-2008
Ad Management by RedTyger
©Tous droits réservés par les parties respectives
Page generated in 0,08444 seconds with 11 queries