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...
> > 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
>|||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...
>> 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...
>> > 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
>>
>
>.
>