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 |
|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 2004-11-01 : 11:56:47
|
| Hello,My Log shipping Restore fails with an error 4323. ( Database is marked Suspect and cannot restore).I found out the reason why this is happening. My Secondary server does not have enough disk space. So I freed up some space on the drive and the Restore is still not occuring on the secondary server. On the Secondary Server the Database still says "Loading/Suspect". So what should be my next step?How do I change the Database so that it will not be "suspect"?If I am able to change the status of the Database then will all the transaction logs ( the ones that failed) restore automatically?Thanks for your help,Maximus. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-01 : 12:18:50
|
| I would restore another full 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. |
 |
|
|
|
|
|
DB in Suspect Mode & Log Shiping Restore fails