Solved

error 9003

Posted on 2004-08-16
5
327 Views
Last Modified: 2008-02-01
/////////////////////////////
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???  
0
Comment
Question by:shadow2004
5 Comments
 
LVL 5

Expert Comment

by:amit1978
ID: 11808505
Probably use the option provided by enterprise sql server to attech the database.

Amit Jain
0
 

Author Comment

by:shadow2004
ID: 11809115
i has been try it but the error message stiil appear.
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 11814219
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now