Welton,
We have a script that runs nightly on our database that contains the
following:
backup log ARSystem with truncate_only
dbcc shrinkfile(ARSystem_log)
This script follows our nightly database backup job.
HTH,
Joe
Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union
Welton Bryant
<[EMAIL PROTECTED]
S-SHAREDSERVICES. To
COM> [email protected]
Sent by: "Action cc
Request System
discussion Subject
list(ARSList)" Transaction log is full.
<[EMAIL PROTECTED]
ORG>
07/12/2007 09:25
AM
Please respond to
[EMAIL PROTECTED]
RG
This is a multi-part message in MIME format.
------_=_NextPart_001_01C7C488.1F8D7B7B
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
=20
Hello,
=20
Can any SQL guru's tell me how to fix this? Thanks
=20
=20
The transaction log for database 'ARSystemdev' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases
=20
Welton Bryant MCSE,MCP=09
Sr. Business Applications Analyst=09
CareTech Solutions Inc.=09
248-823-0341 Office=09
313-408-5188 Cell=09
800-428-4781 Pager=09
[EMAIL PROTECTED] =09
www.caretechsolutions.com <http://www.caretechsolutions.com/> =09
=20
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
------_=_NextPart_001_01C7C488.1F8D7B7B
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
**
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.3086" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007>Hello,</SPAN></FONT></FONT></DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN =
class=3D609402313-12072007>Can any SQL=20
guru's tell me how to fix this? Thanks</SPAN></FONT></FONT></DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN=20
class=3D609402313-12072007>T</SPAN></FONT></FONT><FONT =
face=3DArial><FONT size=3D2>he=20
transaction log for database 'ARSystemdev' is full. To find out why =
space in the=20
log cannot be reused, see the log_reuse_wait_desc column in=20
sys.databases<BR></DIV></FONT></FONT>
<DIV> </DIV>
<DIV align=3Dleft>
<TABLE cellSpacing=3D0 cellPadding=3D0 align=3Dleft border=3D0>
<TBODY>
<TR>
<TD>
<MARQUEE direction=3Dright behavior=3Dslide width=3D165><FONT=20
face=3D"Arial, Helvetica, sans-serif" size=3D2><B>Welton Bryant=20
MCSE,MCP</B></FONT></MARQUEE></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D2>
<MARQUEE direction=3Dright behavior=3Dslide width=3D199 =
height=3D16>Sr. Business=20
Applications Analyst</MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D2>
<MARQUEE direction=3Dright behavior=3Dslide width=3D138 =
height=3D16>CareTech=20
Solutions Inc.</MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D2>
<MARQUEE direction=3Dup behavior=3Dslide width=3D175=20
height=3D16>248-823-0341 Office</MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D2>
<MARQUEE direction=3Dup behavior=3Dslide width=3D175=20
height=3D16>313-408-5188 Cell</MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D2>
<MARQUEE direction=3Dup behavior=3Dslide width=3D175 =
height=3D16>800-428-4781=20
Pager</FONT></MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D3>
<MARQUEE style=3D"WIDTH: 298px; HEIGHT: 20px" scrollDelay=3D500 =
direction=3Dup=20
width=3D298 height=3D20><A class=3Dlinkfu=20
=
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]
aredservices.com=20
</A></MARQUEE></FONT></TD></TR>
<TR>
<TD><FONT face=3D"Arial, Helvetica, sans-serif" size=3D3>
<MARQUEE scrollDelay=3D500 direction=3Ddown width=3D210 =
height=3D20><A=20
class=3Dlinkfu=20
=
href=3D"http://www.caretechsolutions.com/";>www.caretechsolutions.com=20
</A></MARQUEE></FONT></TD></TR></TBODY></TABLE></DIV>
<DIV> </DIV></BODY></HTML>
__20060125_______________________This posting was submitted with HTML in
it___
------_=_NextPart_001_01C7C488.1F8D7B7B--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
