Databases in EM diapppeared when added 6 db's to a total 16 db's

After adding 6 databases to a server for a total 16
databases, the databases in Enterprise Manager just
disappeared. However, it had no problems in viewing the
databases using either DBArtisan or Query Analyzer. Is
this a bug in EM?There is a right click option in 'Databases'
called 'REFRESH' !!!!!
>--Original Message--
>After adding 6 databases to a server for a total 16
>databases, the databases in Enterprise Manager just
>disappeared. However, it had no problems in viewing the
>databases using either DBArtisan or Query Analyzer. Is
>this a bug in EM?
>.
>|||I tried, but still can not view the databases.
Thanks.
>--Original Message--
>There is a right click option in 'Databases'
>called 'REFRESH' !!!!!
>
>>--Original Message--
>>After adding 6 databases to a server for a total 16
>>databases, the databases in Enterprise Manager just
>>disappeared. However, it had no problems in viewing the
>>databases using either DBArtisan or Query Analyzer. Is
>>this a bug in EM?
>>.
>.
>|||HI,
Can you try applying the latest service pack (SP3a) in your client and
verify the same.
No more clues coming to my mind.
Thanks
Hari
MCDBA
"Jeffrey" <jwang@.dot.state.tx.us> wrote in message
news:1b5d01c42709$7d4d3fa0$a601280a@.phx.gbl...
> After adding 6 databases to a server for a total 16
> databases, the databases in Enterprise Manager just
> disappeared. However, it had no problems in viewing the
> databases using either DBArtisan or Query Analyzer. Is
> this a bug in EM?|||I was running into this error on SQL 2000 SP3a.
Thanks.
Jeffrey
>--Original Message--
>HI,
>Can you try applying the latest service pack (SP3a) in
your client and
>verify the same.
>No more clues coming to my mind.
>Thanks
>Hari
>MCDBA
>
>"Jeffrey" <jwang@.dot.state.tx.us> wrote in message
>news:1b5d01c42709$7d4d3fa0$a601280a@.phx.gbl...
>> After adding 6 databases to a server for a total 16
>> databases, the databases in Enterprise Manager just
>> disappeared. However, it had no problems in viewing the
>> databases using either DBArtisan or Query Analyzer. Is
>> this a bug in EM?
>
>.
>

databases disappeared but MDF, LDF still there...

I have been using SQL Server 2000 but not am not an expert on it. I recently
copied databases into a new server using Database Copy Wizard. The previous
databases were copied with no problems. The last one however, still copied
ok but the databases on the "source" server disappeared! I tried
"re-copying" same databases back into the source server but I am getting a
'name conflict' error. From my research, this meant the mdf and ldf files
are still there. Note that I "copied" and NOT "moved" these databases. Can
you please tell me how I can restore these databases? I also tried
re-creating the missing database so I can export data back into it but I got
"Error 5170: Cannot create file 'e:\data\MSSQL\...\.MDF' because it already
exists. etc" Thank you for helping.
_________________
Freedom is nothing else but a chance to be better. (Albert Camus)
One of the reason could be, the source and the destination database file
names could be same.
When you are using copy database wizard, try to modify destination file name
to something else and then try to copy.
Hopefully, it should work.
Thanks
GYK

databases disappeared but MDF, LDF still there...

I have been using SQL Server 2000 but not am not an expert on it. I recently
copied databases into a new server using Database Copy Wizard. The previous
databases were copied with no problems. The last one however, still copied
ok but the databases on the "source" server disappeared! I tried
"re-copying" same databases back into the source server but I am getting a
'name conflict' error. From my research, this meant the mdf and ldf files
are still there. Note that I "copied" and NOT "moved" these databases. Can
you please tell me how I can restore these databases? I also tried
re-creating the missing database so I can export data back into it but I got
"Error 5170: Cannot create file 'e:\data\MSSQL\...\.MDF' because it already
exists. etc" Thank you for helping.
--
_________________
Freedom is nothing else but a chance to be better. (Albert Camus)One of the reason could be, the source and the destination database file
names could be same.
When you are using copy database wizard, try to modify destination file name
to something else and then try to copy.
Hopefully, it should work.
Thanks
GYK