database corrupted? 
Author Message
 database corrupted?

Hi all. Here is my Q.:

I attempted to add two more columns to a table with about 200,000 records
(SQL 2000). I tested it an smaller versions of my DB and it went fine.

However , when I tried to do this on the large DB using EM, it hanged for
good and eventually I had to  kill the EM instance. After that I could not
connect to any database in the SQLSErver installation using EM or SQL
Analyser. Service is running but none of the databases respond. tried to
reboot server (Win2000 Server) to no avail. still no databases are
accessible, meaning not even master DB.

what do I do now? Any other options before reinstalling entire thing and
restoring from latest backups?
I can do it, but it would be nice to just get back into existing databases
if possible.
And I would like to know what I could have done wrong?

Thanks.



Sat, 29 May 2004 07:01:06 GMT
 database corrupted?

It sounds as if SQL Server is rolling back the changes it was in the middle
of applying to your table.  Have you check the SQL Server Errorlog?  Your
best bet is to leave it until the job completes.

Tim


Quote:
> Hi all. Here is my Q.:

> I attempted to add two more columns to a table with about 200,000 records
> (SQL 2000). I tested it an smaller versions of my DB and it went fine.

> However , when I tried to do this on the large DB using EM, it hanged for
> good and eventually I had to  kill the EM instance. After that I could not
> connect to any database in the SQLSErver installation using EM or SQL
> Analyser. Service is running but none of the databases respond. tried to
> reboot server (Win2000 Server) to no avail. still no databases are
> accessible, meaning not even master DB.

> what do I do now? Any other options before reinstalling entire thing and
> restoring from latest backups?
> I can do it, but it would be nice to just get back into existing databases
> if possible.
> And I would like to know what I could have done wrong?

> Thanks.



Sat, 29 May 2004 07:30:02 GMT
 database corrupted?
Tim, sounds like you were right. I left everything as is, came back in the
morning and everything is up
and running. It was probably just taking a long time to process.

So then when I tried to alter the table with 200K records, I should have
left it along, it seems.
I just thought it would take shorter time. I'll try again.


Quote:
> It sounds as if SQL Server is rolling back the changes it was in the
middle
> of applying to your table.  Have you check the SQL Server Errorlog?  Your
> best bet is to leave it until the job completes.

> Tim



> > Hi all. Here is my Q.:

> > I attempted to add two more columns to a table with about 200,000
records
> > (SQL 2000). I tested it an smaller versions of my DB and it went fine.

> > However , when I tried to do this on the large DB using EM, it hanged
for
> > good and eventually I had to  kill the EM instance. After that I could
not
> > connect to any database in the SQLSErver installation using EM or SQL
> > Analyser. Service is running but none of the databases respond. tried to
> > reboot server (Win2000 Server) to no avail. still no databases are
> > accessible, meaning not even master DB.

> > what do I do now? Any other options before reinstalling entire thing and
> > restoring from latest backups?
> > I can do it, but it would be nice to just get back into existing
databases
> > if possible.
> > And I would like to know what I could have done wrong?

> > Thanks.



Sat, 29 May 2004 23:51:13 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Database Corrupted!

2. SQL Databases corrupting with Software RAID

3. Database corrupted?

4. Does Access Database corrupt ???????

5. database corrupted

6. database corrupted

7. Is my database corrupt?

8. 16bit Jet Database Corrupts on Windows 2000

9. Help, access database corrupted

10. database corrupt in vb5

11. Access 2000 database corrupting!

12. Access 2.0 database corrupted [Please read!]


 
Powered by phpBB® Forum Software