Source Code

Solve (LSN) Error 9003 When Attach the Database SQL2000

  • anonymous
  • Oct 11' 13
  • SQL
  • 684
  • 24
  • United States

If you have problem when attaching database like "Error 9003: The LSN (12:32:1) passed to log scan in database 'Database_Name' is invalid." to the sql server, you may try this step:

STEP 1 : turn off your SQL server 

STEP 2 : remove LOG file

STEP 3 : this code for attach single file MDF

USE master;
EXEC sp_detach_db @dbname = 'Database_Name';
EXEC sp_attach_single_file_db @dbname = 'Database_Name',
@physname ='D:\PASARKODE\DATABASE\Database_Name.mdf' 


STEP 4 : turn on your SQL server back


  • Tags :
comments powered by Disqus

Related Code

Zakat Counter

Looking for Date and Time Difference

Send Email Through Console

Program mencari kpk n buah bilangan

Membuat program bilangan n prima

Piramida angka

Error 945 SQL Server 2008

Looping Leaning Figures

Remarks Script Browser

Creating Specification Page Number