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 |
|
BenSwitzer
Yak Posting Veteran
72 Posts |
 Posted - 2003-09-17 : 10:40:26
|
| One of my databases has become corrupted. The LDF is gone and there are no backups for the database. I still have the mdf. I cant detach the database because it is being replicated. I cant remove replication for that since the database is corrupted. Is there anyway I can restore my database. Thanks in advanceBen |
|
|
BenSwitzer
Yak Posting Veteran
72 Posts |
Posted - 2003-09-17 : 13:30:55
|
| Well i researched more and used the emergency switch on the corrupted database. Then i copied the data from one database to a new one. Everything looks ok, but I would still like to get rid of the old database so that I may be able to rename the new one or something equivalent.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-18 : 12:17:58
|
| Why aren't there any backups of the database?Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-18 : 12:33:15
|
| Tryalter database dbname set offline==========================================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. |
|
|
|
hadoft
Starting Member
20 Posts |
Posted - 2003-09-18 : 13:50:06
|
quote:
Well i researched more and used the emergency switch on the corrupted database
what do you mean by "emergency switch" how did you switched it on?? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-18 : 13:53:17
|
| He's probably referring to sp_resetstatus.Tara |
|
|
|
|
|
|
Database corruption prob