Log file is not available

I have a database of around 100 GB. It was de-attached
from the system. When I attach it to the system, it says
log file is not available though it is getting attached.
When I do any transaction, it says Log file is not
available. Kindly HelpHi,
Try to use below DBCC command. Since it a undocumented command please
contact your primary support before usage.
dbcc rebuild_log('dbname','C:\dbname_log.ldf')
Thanks
Hari
MCDBA
"Pankaj Agarwal" <anonymous@.discussions.microsoft.com> wrote in message
news:4c3c01c3ffc3$399864a0$a001280a@.phx.gbl...
> I have a database of around 100 GB. It was de-attached
> from the system. When I attach it to the system, it says
> log file is not available though it is getting attached.
> When I do any transaction, it says Log file is not
> available. Kindly Help|||Hari
Yes it is in case of emergency.
Fully supported way to do it is backup log 'dbname' to... with no_truncate
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OWTx6nBAEHA.2040@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Try to use below DBCC command. Since it a undocumented command please
> contact your primary support before usage.
> dbcc rebuild_log('dbname','C:\dbname_log.ldf')
> Thanks
> Hari
> MCDBA
>
> "Pankaj Agarwal" <anonymous@.discussions.microsoft.com> wrote in message
> news:4c3c01c3ffc3$399864a0$a001280a@.phx.gbl...
>|||Hi
What do you mean my fully supported?. howcan I backup the
logfile when I do not have log file associated with my mdf
file.I mean if I do any transaction, it would first
display a message that log file is not avaialable.Pls
explain as its going out of control.
Regards
Pankaj

>--Original Message--
>Hari
>Yes it is in case of emergency.
>Fully supported way to do it is backup log 'dbname'
to... with no_truncate
>
>"Hari" <hari_prasad_k@.hotmail.com> wrote in message
>news:OWTx6nBAEHA.2040@.TK2MSFTNGP12.phx.gbl...
command please
wrote in message
says
attached.
>
>.
>sql