I have a .dbf file and a .ldf file and I am trying to restore the database in some other system.
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.
When I attach only the .dbf file. The database is created and the working fine. But I am getting error while attaching the .ldf file. What might be the problem.