By Pass mode

Dear All,
I have a database of around 166gb and somehow I lost the
log file. Now its not enabling me to do any transaction as
no log file is avaialable.Database is attached.Now when I
create the log file thru DBCC command (DBCC rebuild_log),
it says "database must be put in Bypass recovery mode to
rebuild the log". Pls advice what's that?pls elaborate. Is
this right way to create the log or there is some
alternate option also to work with my database.
Immmediate solution will be highly appreciated.
Rgds
TriveniThat DBCC command is *not* a safe command. It might leave the database in an
indeterminate state. I suggest you restore from the latest database and all
subsequent transaction log backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Triveni" <anonymous@.discussions.microsoft.com> wrote in message
news:8ee401c4051f$5a7ea1f0$a501280a@.phx.gbl...
> Dear All,
> I have a database of around 166gb and somehow I lost the
> log file. Now its not enabling me to do any transaction as
> no log file is avaialable.Database is attached.Now when I
> create the log file thru DBCC command (DBCC rebuild_log),
> it says "database must be put in Bypass recovery mode to
> rebuild the log". Pls advice what's that?pls elaborate. Is
> this right way to create the log or there is some
> alternate option also to work with my database.
> Immmediate solution will be highly appreciated.
> Rgds
> Triveni|||The worst part is that, we do not have backup of this
database. pls suggest.
Rgds
Triveni

>--Original Message--
>That DBCC command is *not* a safe command. It might leave
the database in an
>indeterminate state. I suggest you restore from the
latest database and all
>subsequent transaction log backups.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Triveni" <anonymous@.discussions.microsoft.com> wrote in
message
>news:8ee401c4051f$5a7ea1f0$a501280a@.phx.gbl...
as
I
rebuild_log),
Is
>
>.
>|||I suggest you open a case with MS Support and have then help you through
this process. They might be able to get back the database and they might
even be able to assist in checking what damage is caused as DBCC REBUILD_LOG
is *not* a safe operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Triveni" <anonymous@.discussions.microsoft.com> wrote in message
news:915e01c4053b$8b1958c0$a501280a@.phx.gbl...
> The worst part is that, we do not have backup of this
> database. pls suggest.
> Rgds
> Triveni
>
>
> the database in an
> latest database and all
> message
> as
> I
> rebuild_log),
> Is