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 |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-09-20 : 02:51:07
|
| I have database restored with no recovery model. I apply new transaction logs all the time and delete them. Now my primary database failed and I dont have new log to restore. How can I recover database without having transaction log to restore. Is some SQL Command like dbcc dbrecover??? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-09-20 : 06:52:58
|
| I think you may be in trouble. You may just have to go back to your most recent backup. Do you replicate the data at all ?===========Paul |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-20 : 07:33:03
|
| >> I apply new transaction logs all the time and delete them.What do you mean by that? What do you apply them to?==========================================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. |
|
|
|
|
|
|
Database recovery