Help Me Friends
Oct 12, 2002Friends,
I have installed Sql Server 7 Desktop edition on Windows 98SE.I created
a application with vb6 and sql server 7.I have created a database sachin.Size of database has grown to 9mb.
While i was trying to restore database sachin through enterprise manager from a backup and cancelled the operation,database was marked as loading.(sachin(loading)).In panic I copied mdf and ldf files of sachin database to other directories and pasted them and delete sachin database.
I tried to attach the database sachin by using sp_attach_db 'sachin','c:datasachin_data.mdf','c"datasachin_log.ldf'
operation ended with following error notes
server:msg 9004,level 21,state 1,line 1
The log for database 'sachin' is corrupt.
connection broken
i am vb programmer,i will lose my job if i could not recover the data.
I request you all to guide and help me .
cthirus@yahoo.co.in