SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem restoring: LSN passed to log scan is invalid


Problem restoring: LSN passed to log scan is invalid

Author
Message
Erich Brinker
Erich Brinker
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 633

I am getting the following error when trying to re-attach a database(DB has data file, Index file, and 2 separate log files). Server is SQL2000 SP3a, OS is Windows 2003

The LSN (88:289:1) passed to log scan in database '<DBname>' is invalid.

I get the error when attaching, and I get the same error when trying to restore from backup.

I have tried restoring to different server but get same error. I have also tried attaching just the data file but get same error. I have also tried using single file restore command and get the same error. I have tried re-setting status and get an error message and the database goes back to suspect/loading mode.

I am out of ideas and thinking Microsoft Suppt is best option unless someone has better ideas

Any help is greatly appreciated


Ana León
Ana León
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

You have to read the following link:

http://dbforums.com/t519971.html

We had the same problem and we followed this solution 1 of Roberto Carrasco and it run!!!


Erich Brinker
Erich Brinker
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 633

Couldn't get the solutions on line to work. The problem ended up being the corrupt log file, but I had to get rid of the secondary index file as well. Ended up just attaching the mdf and using the undocumented command to rebuild the log file

Thanks to everyone and Microsoft for the help getting this one solved.


Paul Randal
Paul Randal
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3727 Visits: 1717
I'm curious - did the PSS person warn you about the consequences of rebuilding the log? Were you instructed to do anything else after rebuilding the log?

Thanks

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Erich Brinker
Erich Brinker
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 633

Yes I was warned about the consequences of rebuilding the log, and for this instance that was acceptable.

After getting the database to come up available, I ended up creating a new database, log file, filegroup, and new file for the indexes. I pushed the tables to the new database and rebuilt the indexes(Microsoft Tech Agreed this would help with more stable database and possibly avoid future corruption).


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search