Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cthirus
Starting Member
1 Post |
 Posted - 2002-10-12 : 05:31:14
|
| Friends,I have installed Sql Server 7 Desktop edition on Windows 98SE.I createda 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:\data\sachin_data.mdf','c"\data\sachin_log.ldf'operation ended with following error notesserver:msg 9004,level 21,state 1,line 1The log for database 'sachin' is corrupt.connection brokeni 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 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-12 : 06:28:37
|
| Restore was half way through so your files are probably no good. Can try sp_attach_single_file_db without the ldf.Other than that you will probably have to restore the latest backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-12 : 12:21:23
|
| As suggested simply restore the database from your backup and let it finish. Since you were restoring a backup when these problems occurred you have not lost anything so don't worry - just let the restore finish. HTHJasper Smith |
|
|
|
|
|
|
Help me Friends