good time to shrink TLog?

sql2k sp3
Ive got a db that I just created 3 days ago and already
the TLog is 5 gigs. I do a Full Backup at 2AM every day
and TLog backups every 5 minutes between 5:AM and 7:PM.
This is a replicated db. Every night before the Full
Backup we turn off replication, truncate 3 tables, bulk
insert new data into those tables, turn on replication.
(Of course that explains the big TLog.) The only way I can
get the size of the TLog down by a signifigant amount is
to do a "backup log with truncate_only" followed by
shrinking the file. Does anyone know, based on this
scenario, when a good time to do this stuff is? I tried
only doing the shrink part but it didnt reduce the size a
whole lot. Is there another way to go about this?
Thanks.Chris
I'm finding some of the things you are doing a little hard
to understand, but that may be due to not having all the
info. What are you using replication for? It seems strange
to turn it off, do some major changes to your database and
then turn it back on. Do you not replicate those changes?
Are you doing a database snapshot following the work? How
are you keeping you databases in line with this process?
One possible solution for your actual problem, depending
on disk space and DR strategy, would be to take a full
backup before the changes, go to simple recovery mode.
Perform the changes. Switch back to full recovery after
the changes and take another full backup. This should cut
down on the growth to your transaction log.
I think a better understanding of your replication usage
may lead to a better solution.
Regards
John|||What are you using replication for? It seems strange
>to turn it off, do some major changes to your database
and
>then turn it back on.
So our client can access this data. I need to turn off
replication because I need to truncate these table @. night.
Do you not replicate those changes?
>Are you doing a database snapshot following the work?
Yes. These tables are in their own Publication and it gets
re-snapshotted every night.
How
>are you keeping you databases in line with this process?
Not sure I get this one?
So do you know of a good time I could truncate and shrink
the log?
>--Original Message--
>Chris
>I'm finding some of the things you are doing a little
hard
>to understand, but that may be due to not having all the
>info. What are you using replication for? It seems
strange
>to turn it off, do some major changes to your database
and
>then turn it back on. Do you not replicate those changes?
>Are you doing a database snapshot following the work? How
>are you keeping you databases in line with this process?
>One possible solution for your actual problem, depending
>on disk space and DR strategy, would be to take a full
>backup before the changes, go to simple recovery mode.
>Perform the changes. Switch back to full recovery after
>the changes and take another full backup. This should cut
>down on the growth to your transaction log.
>I think a better understanding of your replication usage
>may lead to a better solution.
>Regards
>John
>.
>|||Chris
Is my suggestion to change the recovery mode during the
busy period not an option then? That way you should not
need to shrink the log. Whilst it may not always possible,
I would like to set up systems so your database and tlog
are the correct size and don't require shrinking. It's not
a good practice to perform regular shrinks.
Just a thought, are you perfomrning regular tlog backups?
By the way how big is your database?
Regards
John

good performance tuning book

Can someone please recommend a good SQL2k performance tuning book?
sql2k sp3
TIA, ChrisR
_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>
|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Boo...sbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.

good performance tuning book

Can someone please recommend a good SQL2k performance tuning book?
--
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.

good performance tuning book

Can someone please recommend a good SQL2k performance tuning book?
sql2k sp3
TIA, ChrisR_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_
by Ken England, Digital Press
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"ChrisR" <ChrisR@.NoEmails.com> wrote in message
news:eHwfCmGwEHA.536@.TK2MSFTNGP11.phx.gbl...
> Can someone please recommend a good SQL2k performance tuning book?
>
> --
> sql2k sp3
> TIA, ChrisR
>|||On Mon, 1 Nov 2004 15:21:43 -0800, "ChrisR" <ChrisR@.NoEmails.com>
wrote:
>Can someone please recommend a good SQL2k performance tuning book?
I believe this is the book I was browsing the other day, that seemed
to have some excellent chapters on tuning, not just BOL reprints.
http://search.barnesandnoble.com/Bo...isbn=0672324679
Microsoft SQL Server 2000 Unleashed, 2nd Edition
Ray Rankins, Paul F. Bertucci, Paul Jensen
Pub. Date: December 2002
ISBN: 0672324679
Format: Paperback, 1513pp
Publisher: Pearson Education
Edition Number: 2
J.

Good documentation tool

hi all,
if anybody could direct me to a free DB documentation tool for SQL2K that'll
be great. Since we're running out of budget (usual year end crunch, blah
blah!), we cannot budget for buying any new tool...if anyone also knows diff
tools that could be used within SQL2K, pls suggest in brief how to make use
of it for documenting Tables, Triggers, Relation Diagram and Data Dictionary
TIA
I wrote an article on "DB documentation" last year. I have provided the sql
scripts also. Check out http://www.microsoft.com/india/msdn/articles/169.aspx
whether it would be of any help to you.
Pls be adviced that you might need to change the scripts to adhere to ANSI
Joins if at all you are bothered about performance.
Best Regards
Vadivel
http://vadivel.blogspot.com
http://thinkingms.com/vadivel
"parasada" wrote:

> hi all,
> if anybody could direct me to a free DB documentation tool for SQL2K that'll
> be great. Since we're running out of budget (usual year end crunch, blah
> blah!), we cannot budget for buying any new tool...if anyone also knows diff
> tools that could be used within SQL2K, pls suggest in brief how to make use
> of it for documenting Tables, Triggers, Relation Diagram and Data Dictionary
> TIA

Good book about replication in SQL2k?

I want to buy good book about replication in SQL2k. Mostly I interested in
transaction replication. Are any good books about it?
I know about book of Hilary Cotter "A Guide to SQL Server 2000 Transactional
and Snapshot Replication", from content it looks like it is what I need, but
the book is unavaiblable on Amazon. Are any other good books?
I'm wondering which country you are sending from?
I can fully recommend Hilary's book and have found it on www.amazon.com:
http://www.amazon.com/Guide-Server-T...e=UTF8&s=books
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I am from Moscow, Russia.
On Amazon I see:
Availability: Available from these sellers.
2 used & new available from $59.99
It is not available from Amazon, only from some sellers. And when I try to
order it, it says it can not ship it to Russia. Just few days I ordered
several books about SQL2k5, the book are selled directly by Amazon. It was
shipped. But, I think, since the books is not selled directly by Amazon I can
not order it.
"Paul Ibison" wrote:

> I'm wondering which country you are sending from?
> I can fully recommend Hilary's book and have found it on www.amazon.com:
> http://www.amazon.com/Guide-Server-T...e=UTF8&s=books
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - sorry but I have no idea which book sellers will ship to Russia. Maybe
you can post this on the Microsoft SQL Russian newsgroup, or maybe Hilary
knows?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||SQL Server 2000 Unleashed has a fantastic section on replication (and
everything else). Highly recommended.
Paul Ibison wrote:
> OK - sorry but I have no idea which book sellers will ship to Russia. Maybe
> you can post this on the Microsoft SQL Russian newsgroup, or maybe Hilary
> knows?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||write to my wife at mtcotter @. hotmail.com
I think she has some for sale.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:6EAF55C8-9FAC-43FC-AC54-123C53817326@.microsoft.com...[vbcol=seagreen]
>I am from Moscow, Russia.
> On Amazon I see:
> Availability: Available from these sellers.
> 2 used & new available from $59.99
> It is not available from Amazon, only from some sellers. And when I try to
> order it, it says it can not ship it to Russia. Just few days I ordered
> several books about SQL2k5, the book are selled directly by Amazon. It was
> shipped. But, I think, since the books is not selled directly by Amazon I
> can
> not order it.
>
> "Paul Ibison" wrote: