Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Database (Sospechoso)

Author  Topic 

aolivera07
Starting Member

3 Posts

Posted - 2008-06-16 : 16:02:33
Hola a todos Tengo una Base de Datos en SQL 2000 y la misma se me marco como sospechoso y no tengo acceso a la misma, como puedo quitarle esta marca.

Gracias de Antemano.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-16 : 16:04:13
Could you translate to English for us?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

aolivera07
Starting Member

3 Posts

Posted - 2008-06-16 : 16:23:23
hello, I've a problem whit DB SQL2000. Don't open the BD. It Has the mark SUSPECT FOR RECUPERATION. HOW CAN I GET THE ACCESS FOR THE BD

THANK YOU SO MUCH ALEX.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-16 : 16:38:44
Have you run sp_resetstatus?

Do you have backups of the database?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

PCpsyco
Starting Member

11 Posts

Posted - 2008-06-18 : 20:16:37
primero como fue que se marco como sospechosa? la borraste y la volviste a remplasar o simplemente se corrupto?

dos cosas, pudes correr

EXEC sp_resetstatus 'elnombredetubasededatos';

en un nueva query, utilisando el enterprise manager.
la otra es que si borraste la base de datos y la pusiste en otro lugar, regresala a donde estaba.

Andy
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-06-19 : 04:52:02
Please make your posts in english som everybody can understand.

- Lumbago
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-19 : 05:05:04
For you who don't speak a Nordic language, "som" translates into "as" (or "which") in english.


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-06-19 : 05:13:15
quote:
Isn't "som" a nordic word that translates to "as" (or "which") in english?
Umh...sure...or a typo for "so"

- Lumbago
Go to Top of Page
   

- Advertisement -