• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

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???  
1 Solution
Probably use the option provided by enterprise sql server to attech the database.

Amit Jain
shadow2004Author Commented:
i has been try it but the error message stiil appear.
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.

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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now