Uma,

Here is one explaination
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/38808;pt=38273.
Search for "bypass" on this page. Its not much but may give you a
hint.

S. Davey (1/31)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "UmaShankar "
<mssqldba-ezmlmshield-x64694599.[Email address protected] 01/31/07
5:26 AM >>>
Hi,

When I run dbcc dbreindex (agent_dtl,'', 75)

It gave folowing Error msg



Could not run BEGIN TRANSACTION in database 'Tssas_Live' because the
database is in bypass recovery mode.



Any help please...................................



Thanks & Regards,

Uma




Confidential: This electronic message and all contents
contain information from TRANS CONTINENTAL e-SERVICES, PVT LTD . which
may be
privileged, confidential or otherwise protected from disclosure. The
information is intended to be for the addressee only. If you are not
the
addressee, any disclosure, copy, distribution or use of the contents of
this
message is prohibited. If you have received this electronic message in
error,
please notify the sender immediately and destroy the original message
and all
copies.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page