Backup transaction log in a damaged database

I would like to ask how to backup a transaction log file if the database is
damaged or the harddisk crash. When I can't start the database, is that
possbile to backup the transaction log?
Thanks in Advance
BlackBlack
As long as your master database is up you should be able
to issue the backup command. You then may or may not be
able to successfully backup the transaction log. It
depends on what kind of problems you have.
You have put your transaction log on a different drive
from your database, havn't you? If you have not, you
probably will not be able to get at it.
Regards
John|||This is exactly what the NO_TRUNCATE option of the RESTORE is used for. Read about it in Books
Online.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Black" <hoodworld@.hotmail.com> wrote in message news:%23KStQUPrDHA.3256@.tk2msftngp13.phx.gbl...
> I would like to ask how to backup a transaction log file if the database is
> damaged or the harddisk crash. When I can't start the database, is that
> possbile to backup the transaction log?
> Thanks in Advance
> Black
>|||Hi all,
In fact, I am now testing the recovery function of SQL server. In fact, I
read the KB 253817 articles.
I establish the databases and prepare these files.
old_data.MDF
old_log.LDF
lastest_log.LDF - modified data based on old_log.LDF
I stop the server try to replace to old_log.LDF with lastest_log.LDF (Both
are in the same DB structure). However, I failed to run the BACKUP LOG ...
WITH NO_TRUNCATE. I am at a lose now, so I wonder if it's possbile to backup
the log in this case.
Kenneth
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
¼¶¼g©ó¶l¥ó·s»D:ep1XWVQrDHA.1948@.TK2MSFTNGP12.phx.gbl...
> This is exactly what the NO_TRUNCATE option of the RESTORE is used for.
Read about it in Books
> Online.