ERROR 9003 : the LSN .... - SQL Server Forums

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)

ERROR 9003 : the LSN ....

Author

Topic

djokerss
Starting Member

28 Posts

Posted - 2005-01-18 : 22:15:50

When i start my mssql , i lost my database ( suspect ) , when i check the disk the database is exists,
so i want to attach it , but there's an error message
"Error 9003 : The LSN(43:172:1) passed to log scan in database "dbname" is invalid"

anyone can help me.....i'm afraid if i lost my data....

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-01-18 : 23:35:20

Try a single file attach.

Example from BOL:


Examples
This example detaches pubs and then attaches one file from pubs to the current server.

EXEC sp_detach_db @dbname = 'pubs'
EXEC sp_attach_single_file_db @dbname = 'pubs', 
   @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

djokerss
Starting Member

28 Posts

Posted - 2005-01-19 : 03:58:12

it's still don't work,
i've try sp_attach_single_file_db and sp_attach_db

can we restore a database from .mdf or .ldf ?
or fix .mdf or .ldf ?

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-01-19 : 21:51:21

No. You're supposed to have these kewl things called backups.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources