stopped Log shipping, but can not change the read-only mode

[mm8294]

We have setup log shipping on our prod database APPLE. The destination database is configured to be in standby mode. The log shipping has been running well, and the destination database is always in ReadOnly mode. And today we have stopped log shipping. But by mistake, the source database was deleted, and all the log files shipped to the destination server have been deleted, too. So now we have only a readonly APPLE database on destination server, no translog.

In this case, is there anyway to change the destination database from readonly to read-write? I have tried many times, but it always complain that 'The RESTORE statement could not access file ...APPLE_2006...tuf'.

Please help.

Thanks in advance.

 

[Catadmin]

You need to run a restore statement using WITH RECOVERY.

Literally, Restore Database <MyDB> With Recovery. Check Books Online to verify the syntax, but I don't believe you need anything else. You certainly don't need file paths.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mm8294]

Catadmin, I did run the command 'restore database apple with recovery', and I got error 'The RESTORE statement could not access file ...APPLE_2006...tuf'.

As far as I know, this command will try to apply the last log file first, then change the mode from readonly to read-write. But, I don't have that log file, and I don't want it to apply any log file.