Restore Database in Standby without a Transaction undo file

Is there a way to restore a database that is in stand-by mode, if the TUF
file has become corrupted or accidently deleted.
If you do a resotre database with recovery you will get an error saying the
file is not accessiable. Is there a way to force the restore.
You can stop SQL, copy the files and re-attach I think.
It would also be nice if SQL could backup database that are in standby. This
way you can do quick offsite backups.Hi,
AFAIK, IF the TUF file (undo file) is corrupted or lost you can not restore
the subsequent transaction logs in to your database which is in
stand by mode.
Thanks
Hari
SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.|||If the standby file is hosed, so are you. I submitted a SQLWISH a while ago
for SQL Server to lock the standby file just as it does any SQL database
file. I don't know the status of that request.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.