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 RepliesFriends,
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
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