error 9003

/////////////////////////////
I am using the follwing syntax to attach the database

EXEC sp_attach_db @dbname = N'<bpl>',
   @filename1 = N'd:\newdatafiles\bpl_2000_data.mdf',
   @filename2 = N'd:\newdatafiles\bpl_2000_log.ldf'

When I am doing so I am getting the following error
---
Server: Msg 9003, Level 20, State 1, Line 1
The LSN (70:729:1) passed to log scan in database 'bpl' is invalid.
Connection Broken
---
/////////////////////////////

I got this problem too, and i already read all helper's comment. The next question is, how can i attach this database
again to sql server???  
shadow2004Asked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
This usually means the logfile is corrupted or invalid.  Have you verified the SQL Server version for the destination server is the SAME (or newer) version as the source SQL Server?  If they aren't equivelent versions, you'll get this error too.

Brett
0
 
amit1978Commented:
Probably use the option provided by enterprise sql server to attech the database.

Amit Jain
0
 
shadow2004Author Commented:
i has been try it but the error message stiil appear.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.