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.
| Author |
Topic |
|
pucci70
Starting Member
20 Posts |
 Posted - 2002-08-09 : 04:12:13
|
| When attach my DB (7 > 20000) have a strange error:Server: Msg 9003, Level 20, State 1, Line 1The LSN (632:189632:1) passed to log scan in database 'bilancilin' is invalid.Connection Brokenyou can help me?thanks a lot!-----------------Good Work! |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-09 : 08:57:21
|
| Did you use sp_detach_db to remove the database from SQL7. Do you have backups ? First thing to do is try and attach it back to SQL7 and see if that produces the same error. If no error then issue a checkpoint and detach it from SQL7 again and try and reattach to 2000. If it still a problem , just attach the MDF file using sp_attach_single_file_db to 2000 - this should create a new empty log file for you. You will need to increase its size.If you get the same errors in SQL7 then restore a backup and follow the same process as above and see if that works. Just make sure you have copies of your mdf and ldf files before you try any of this.HTHJasper Smith |
 |
|
|
pucci70
Starting Member
20 Posts |
Posted - 2002-08-09 : 15:30:31
|
| Thanks a lot but I finds the solution: *.MDF file (is over 9GB) is corrupted!-----------------Good Work! |
|
|
|
|
|
|
Error when attach a database!