Help Me Friends

Oct 12, 2002

Friends,

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

View 1 Replies


ADVERTISEMENT

Help Me Friends...

Oct 18, 2005

Dear All,I am a software programmer at initio i wish to improve my back-end side in SQL Server 2000.I wish to learn it asap and i wish to become Database Administrator.So, I need your help as i am a beginner and if you have any links or turorial to learn it please provide me.Thanks.Truly yours,Max

View 3 Replies View Related

Problems With Script @ Swynk/friends/wunder/sql7.asp

Dec 20, 2001

I created the admin database and all the scripts provided at this link. When I tried to run them I found that the master..spOAGetProperty etc stored procedures are not present in my installation. I have SQL Server 7 Standard.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved