Repair a Sql Server

Hi,
I have an instance of Sql Server 2000 on a Windows Server 2000
The server has 2 mirror hard disk
On disk failed and we replace it by a new one
Since than, some DTS does not work because the connection to another
database on the same server failed
Also the Console Entreprise Manager can not connect to all database
If a create a new registration from a remote computer the registration work
and I can see all the database
It seem's that some files are corrupted on the server
Is there a way to do a repair on SqlServer 2000?
If yes How can I do that?
Or what should I do to resolve the problem?
Thanks in advance?
firstly to be sure if SQL server databases are corrupted, you can check
by doing DBCC CheckDB on all the databases
|||It sounds like your redundant disk array isn't. Find and fix any disk
corruption issues, then you can restore the SQL Server. I have found that
fixing databases in place with underlying file system corruption to have
very poor success rates.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"GC" <GC@.discussions.microsoft.com> wrote in message
news:B7E33597-020E-49BB-B91A-3D181A020FF5@.microsoft.com...
> Hi,
> I have an instance of Sql Server 2000 on a Windows Server 2000
> The server has 2 mirror hard disk
> On disk failed and we replace it by a new one
> Since than, some DTS does not work because the connection to another
> database on the same server failed
> Also the Console Entreprise Manager can not connect to all database
> If a create a new registration from a remote computer the registration
> work
> and I can see all the database
> It seem's that some files are corrupted on the server
> Is there a way to do a repair on SqlServer 2000?
> If yes How can I do that?
> Or what should I do to resolve the problem?
> Thanks in advance?