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 when attaching Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-22 : 08:20:42
kaddu writes "hi ,
I am getting error when attaching Database on SQL 2000 SP3
The LSN (21865:3620:1) passed to log scan in database 'PRD' is invalid. Is any clue ?"

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-12-22 : 12:29:15
quote:
Originally posted by AskSQLTeam

kaddu writes "hi ,
I am getting error when attaching Database on SQL 2000 SP3
The LSN (21865:3620:1) passed to log scan in database 'PRD' is invalid. Is any clue ?"



This error indicates that you are attempting to attach an MDF and LDF that are not in synch with each other. Please post your sp_attach_db command and also verify that your datafiles are in the directory you think they are in.

Or you could be trying to attach an access database to SQL Server, but you aren't doing that right?


-ec
Go to Top of Page
   

- Advertisement -