LSN invalid?

• cyff

  Newbie

  Points: 4

  More actions

  November 12, 2004 at 2:03 am

  #109510

  Hi,hello

  I used the physical file to attach the database:

  sp_attach_db db,path of .mdf,path of .ldf

  The returned message was :

  The LSN (45512:185:1) passed to log scan in database 'db' is invalid.

  What's matter? How it's to solve?

  Thanks in advance

• November 15, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Marsha Pierce

  SSC-Addicted

  Points: 458

  More actions

  November 15, 2004 at 1:52 pm

  #530179

  I would try attaching the DB using a single file 

  exec sp_attach_single_file_db 'dbname',

        'pathname\dbname_data.mdf'

  This will create a new log file so you will need to rename your old log file.

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 15, 2004 at 3:48 pm

  #530193

  Here is another thread

  http://qa.sqlservercentral.com/forums/shwmessage.aspx?messageid=105032

  Also, what SP are you running there was a bug with restores and attaching databases that was fixed in I want to say SP3

  Wes