Terima kasih untuk supportnya mas.
SQL Server 2000 :
Saya sudah coba di pc lain .. tetap error..
1. coba dengan ldf lain , copy dan rename spy sama
2. attach secara wizard melalui enterprise manager
3. attach secara manual melalui query analyser
EXEC sp_attach_db @dbname = 'MI',
@filename1 = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\MI_DATA.mdf',
@filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MI_LOG.ldf'
(dg ldf
copyan , tujuannya agar create sendiri)
(dg ldf
aslinya , tetap error)
EXEC sp_attach_single_file_db @dbname = 'MI',
@physname = 'C:\MI_DATA.mdf'
(tanpa ldf
, tujuannya agar create sendiri)
Message Error :
Error 5172 : The Header for file 'C:\MI_LOG.LDF' is not a valid database file
header.
The FILE SIZE property is incorect.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'MI'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MI_Log.LDF' may be incorrect.
Error 1813 : Could Not open new database 'MI', CREATE DATABASE is aborted
device activation error. The physical file name 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MI_LOG.ldb May be Incorrect.
____________________________________________________________________________________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
