An up-to-the-point recovery .Is it possible with MS SQLserver?

I asked how to apply the latest log when DB is crashed.
Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
But if both .mdf and .ldf are not avaible.what to do..
Informix way of backup
1)automaticaly backup its log when the log is full,(instead of based on
schedule)
2)backup its log when the server is crashed.
I hope Sql-server can handle it this way.is it possible?
Thanks!If the server has crashed how could it reliably make a backup? If you have
lost your disks or files, then you have no option but to go to a tape (or
other remote location) for a backup file(s). Which is why it is so
important to use a fault tolerant disk subsystem.
If you haven't lost the files, then you should be able to make a backup of
the log using the NO_TRUNCATE option and then use that backup and any
previous log backup files to recover to the point of the crash.
"Straight" <someone@.> wrote in message
news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> I asked how to apply the latest log when DB is crashed.
> Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
> But if both .mdf and .ldf are not avaible.what to do..
> Informix way of backup
> 1)automaticaly backup its log when the log is full,(instead of based on
> schedule)
> 2)backup its log when the server is crashed.
> I hope Sql-server can handle it this way.is it possible?
> Thanks!
>