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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Data base marked suspect.

Author  Topic 

nmunoz
Starting Member

1 Post

Posted - 2005-09-28 : 23:10:53
I have a client database marked suspect becouse we lost the log device datafile, and there is no Buckup.

¿how can I recover that database? Is on SQLSever 6.5 on NT 4.0 SP5.

Thanks.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-09-28 : 23:34:51
wow, this is about the worst of all situations.

read these articles very carefully. make sure that you backup whatever datafiles you currently have (while the database is offline) in case you make a mistake.

http://support.microsoft.com/default.aspx?scid=kb;en-us;180500
http://support.microsoft.com/kb/165918/


-ec

Go to Top of Page
   

- Advertisement -