passed to log scan mssql 2000

I was dilemma last weekend. Now that our server has faced such error message “passed to log scan” while attaching database with MS.SQL 2000 enterprise manager. For this case, I was stack on this error and trying to get data from *.mdf file on anyway like seeking in Google. Fortunately, I’ve found www.ureader.com pointing out these kinda error message, how to solve it.

I did the instruction of this blog. But, it was not fine and showed my database is marked as Emergency mode. At that time, I have had an idea to retrieve the included datas from *.mdf with by the way of using SQL Query Analyzer. Thanks God. Cause I can retrieve all included data by Query Analyzer but one left is how to migrate the data from the database marked as Suspend mode to another new database. I was supposed to set all data into text output with Query Analyzer or something else. But, anything would be ok. Finally, I’ve create black database and using follow query string to migrate new database as to recover my database.

SELECT * INTO NewTable FROM existingdb.dbo.existingtable

Best Credit to :http://www.ureader.com/msg/1145136.aspx http://snippets.dzone.com/posts/show/372