what about update stats? doesn't that play in here somewhere? and if so,
is it time intensive?



>>> "Anthon Mark J - DOA "
<mssqldba-ezmlmshield-x24243475.[Email address protected] 9/28/2006 8:46
AM >>>

I will continue to share whatever knowledge I have, whenever I can.
In
fact, in anticipation of the next tran-log inquiry, here's the two
step
process once again, for those of you new to the group or those of you
who have not yet mastered the highly complex "cut & paste" technique,
which takes years to perfect:

To put out the immediate fire (the band aid approach):

Step One: BACKUP LOG database_name WITH TRUNCATE_ONLY

Step Two: dbcc shrinkfile (log_name,truncateonly)






-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x78439759.[Email address protected]
Sent: Thursday, September 28, 2006 10:15 AM
To: LazyDBA Discussion
Subject: RE: kinda quick solution needed to truncate transaction log

That depends on where you are. In the land of down under it already is
Friday. :)

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x30987813.[Email address protected]
Sent: Thursday, September 28, 2006 11:10 AM
To: LazyDBA Discussion
Subject: RE: kinda quick solution needed to truncate transaction log

Phew! Oh my! Temperrrrrrrr! Don't worry! Be happy! It's almost
Fridayyyyy! Partyyyyyyy! Hehe.




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


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