Good point
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x64297875.[Email address protected]
Sent: Thursday, September 28, 2006 11:02 AM
To: LazyDBA Discussion
Subject: RE: kinda quick solution needed to truncate transaction log
Ahhhhh, yes! Aye cha! Hehe.
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Steve Hughes
[mailto:mssqldba-ezmlmshield-x12452505.[Email address protected]
Sent: Thursday, September 28, 2006 11:57 AM
To: LazyDBA Discussion
Subject: RE: kinda quick solution needed to truncate transaction log
Thats all very well, but some people have only just joined this group -
this week in fact so hav'nt seen these post before. Re stating that
people should take notes don't help if you have not seen the post
before
------ Original Message ------
Received: Thu, 28 Sep 2006 04:12:15 PM BST
From: "Anthon Mark J - DOA "
<mssqldba-ezmlmshield-x73485197.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: RE: kinda quick solution needed to truncate transaction log
Differ with what? That we've covered this topic/solution time and time
and time again? . . . beg all you want, there's nothing to differ with
John, those are the cold hard facts my "nirvana-seeking" friend. And
don't tell me what I need to find pal . . . these so called DBA's need
to find a pencil and paper (can you say "take notes?") or take a SQL
class.
Anyone care to wager how long before we see the next "Help, how do I
shrink my tran log?" :)
Have a great weekend!
-----Original Message-----
From: John A DAVIS
[mailto:mssqldba-ezmlmshield-x25079447.[Email address protected]
Sent: Thursday, September 28, 2006 9:38 AM
To: LazyDBA Discussion
Subject: RE: kinda quick solution needed to truncate transaction log
I beg to differ. Posting my question brought in all sorts of good advice
that I am filing away in my already full library of code . . .er . . .
.I mean library of scripts. Luckily (for you, but not for the list)
everyone emailed me personally with some great extra ideas that I had
never heard before.
Now, I DID go and search the archives AND BOL. The archives just gave me
threads that I had replied to showing different ways to truncate a log
file. All of these I couldn't use for my particular situation. I needed
the simple syntax "backup with truncate_only" and I needed it quick and
it worked once I found it. Now, go and try to find this in BOL, Gewgle,
or LazyDba archives. It is not an intuitional syntax. I took a chance
that someone at the time was reading their emails (you weren't--your
reply was a day late).
You need to find Nirvana (love and compassion) like Ed E. and everyone
that helped me. Everything else is Samsara(birth, death, misery). :)
I am done and I am so grateful to this list.
Sincerely,
John A. Davis
CrazyDBA
>>> "Anthon Mark J - DOA "
<mssqldba-ezmlmshield-x56083159.[Email address protected] 9/27/2006 5:47
AM >>>
C'mon People,
We go over and over this topic multiple times each week! Does anyone
take notes anymore?????
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)
Then re-evaluate the need for tran-logs and if needed, incorporate the
above steps in a nightly backup job.
I'm gonna save this email and just cut and paste it next week, when the
same question comes up.
-----Original Message-----
From: John A DAVIS
[mailto:mssqldba-ezmlmshield-x69952693.[Email address protected]
Sent: Tuesday, September 26, 2006 10:25 AM
To: LazyDBA Discussion
Subject: kinda quick solution needed to truncate transaction log
sql server 2000
the transactions can be re-run
we have a bloated transaction log that is stopping everything can't find
the syntax
tia
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
regards
steve hughes
---------------------------------------------------------------------
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